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!

List all roles and users with access to a schema

osheajimMar 8 2013 — edited Mar 8 2013

Hi
We have a large database with serveral schemas. Our auditors want a list of all users and roles which can access the factory schema. Is there a query I can run to find this.

Through goolge I can get queries on tables but nothing for an entire schema.

Thanks
Jim

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2013

Added on Mar 8 2013

#general-database-discussions

4 comments

14,305 views