Home » RDBMS Server » Security » user roles (Oracle 9.2.0.6.0 on SunOS 5.9)
user roles [message #300175] Thu, 14 February 2008 08:47 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
Hi, i have a db with 1k users aprox.
My idea is to see witch role have each user.
i was searching on user_role_privs view but i cant found a relation between username and roll that he has

does anyone have an idea about where to find (i am reading documentation but i cant find that view)
thank you in advance

Report message to a moderator

Re: user roles [message #300181 is a reply to message #300175] Thu, 14 February 2008 08:56 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DBA_role_privs

Regards
Michel

Report message to a moderator

Previous Topic: How do I log into Oracle via LDAP? Is there an example?
Next Topic: revoke grant privilege from user's own object
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 03:22:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.