Problem to Create ROLE

Posted in 2007

Summary

dungdang, on IDS 7.3 Solaris, created a role, granted SELECT on several tables to it, granted the role to user2 and set the role, but user2 still could not read some tables. Claus Samuelsen said GRANT on multiple tables in one statement is unsupported and must be one table per statement. dungdang retried table by table, still failed, and asked whether table ownership matters. Unresolved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Security, Permissions & Auditing, Platform-Specific Issues

dungdang — Wed, 08 Aug 2007 03:21:31 -0700 — source: Usenet: comp.databases.informix

We ve an IDS v7.3 on Solaris Unix. I want to user accessibility to tables based on Roles. I've attempted to ceate a Role and add user but still user can't access the table but a different table which I didn't define in thr Role. here are te comands are I've used: 1. GRANT CONNECT TO Public 2. GRANT CONNECT TO user2 3. CREATE ROLE rol_select 4. GRANT Select ON table1,table2,table4 TO rol_select 5. GRANT rol_sel TO user2 6. SET ROLE rol_select Is there a problem here? okg

↪ replying to dungdang

dungdang — Wed, 08 Aug 2007 03:24:06 -0700 — source: Usenet: comp.databases.informix

We ve an IDS v7.3 on Solaris Unix. I want to user accessibility to tables based on Roles. I've attempted to ceate a Role and add user but still user can't access the table but a different table which I didn't define in thr Role. here are te comands are I've used: 1. GRANT CONNECT TO Public 2. GRANT CONNECT TO user2 3. CREATE ROLE rol_select 4. GRANT Select ON table1,table2,table4 TO rol_select 5. GRANT rol_select TO user2 6. SET ROLE rol_select Is there a problem here? okg

↪ replying to dungdang

Claus Samuelsen — Wed, 08 Aug 2007 13:43:52 +0200 — source: Usenet: comp.databases.informix

dungdang wrote: > 4. GRANT Select ON table1,table2,table4 TO rol_select This syntaxt is not supported. You have to grant on one table per sentence: GRANT Select ON table1 TO rol_select GRANT Select ON table2 TO rol_selectetc

↪ replying to Claus Samuelsen

dungdang — Wed, 08 Aug 2007 18:15:31 -0700 — source: Usenet: comp.databases.informix

Hi, I did add the tables one at a time but still user can't access some of the tables. does't have to do with table ownership? I'm using Informix user (the dba) but some of those tables are owned by another user. I think DBA can GRANT access to any table to anyone.. On Aug 8, 11:43 am, Claus Samuelsen <c...@dk.ibm.com> wrote: > dungdang wrote: > > 4. GRANT Select ON table1,table2,table4 TO rol_select > > This syntaxt is not supported. You have to grant on one table per sentence: > > GRANT Select ON table1 TO rol_select > GRANT Select ON table2 TO rol_select> etc

Glossary

IDS (Informix Dynamic Server)