Roles and Privileges 1

[dbadmin]

Hi,

I am running into an issue which I cannot figure out. Any help from the experts is really appreciated.

I have a view VIEW1 owned by USER1 which does some select statements against dba_users view owned by SYS.

USER1 has granted select privileges on VIEW1 to a Role ROLE1.

SYS granted select privilege on DBA_USERS to ROLE1 as well as USER1.

I have granted ROLE1 to USER2 and USER2 has set default role all.

But when USER2 logs in and does a select against VIEW1, he gets "Insufficient Privileges" message.

When USER2 has "select any table" privilege he doesn't run into this error. But that privilege cannot be given because of security issues. Any help is really appreciated.

Thanks,
dbadmin

 

[Dagon]

User1 may need to be granted access to DBA_USERS "with grant option" in order to be able to pass on his access to user2.

 

[dbadmin]

Thank you so much. That fixed the problem

dbadmin.