Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Users, their roles & the objects they have access to.

Status
Not open for further replies.

jbsys

Programmer
May 6, 2005
51
CA
How can I get a list of users, thier roles, and objects that they have access to along with the priviledges granted?


Thanks
 

Query the following tables:

{DBA/ALL}_tab_privs
{DBA/ALL}_role_privs
{DBA/ALL}_sys_privs

[2thumbsup]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top