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!

Identifying users without DEFAULT ROLE ALL

mtefftJan 5 2011 — edited May 25 2011

I want to query the database catalog to identify users who have been defined without DEFAULT ROLE ALL. Unfortunately I do not see anything in DBA_USERS that would tell me this.

I suppose I could run DBMS_METADATA.EXTRACT_DDL to generate scripts for all users, and examine the output, but I would like something more direct.

Thanks,
Mike Tefft

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2011

Added on Jan 5 2011

#general-database-discussions

4 comments

1,058 views