Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

defrole Info with select_catalog_role

140720Aug 9 2006 — edited Aug 9 2006
I read the view dba_tab_roles with a user having the select_catalog_role.
dba_tab_roles contains a field default_role.
If this fields contains the value YES, sometimes the role has to be added to the user as default role with the command
alter user xxx default role r1,r2,..;

The table sys.user$ contains a field defrole.
Reading this field I can decide if the alter user xxx default role .... command is required or not.
Unfortunately I have to connect as dba to see the table sys.user$, with a user having only the select_catalog_role I'm not able to access this table.
Where can I find this info using a userid having only the select_catalog_role?

Thanks
Tauber Johann
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2006
Added on Aug 9 2006
3 comments
731 views