Home » RDBMS Server » Security » How to know which role I was granted?
How to know which role I was granted? [message #22151] Wed, 25 September 2002 14:10 Go to next message
Swamy
Messages: 78
Registered: June 2002
Member
Application admin created some roles. The admin then created one username for me and granted one of the roles to that username. I logged in as that username, but how can I know, which role I was assigned? This one I want to know from a query. Can any one help me?

Report message to a moderator

Re: How to know which role I was granted? [message #22152 is a reply to message #22151] Wed, 25 September 2002 15:00 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
select * from user_role_privs;

Report message to a moderator

Re: How to know which role I was granted? [message #22160 is a reply to message #22151] Thu, 26 September 2002 07:20 Go to previous message
Azmat
Messages: 8
Registered: July 2002
Junior Member
Thanx,

That was so simple :)

regards
Azmat

Report message to a moderator

Previous Topic: URGENT - Grant DBA PRIVS TO USER
Next Topic: What is my UserName, Password and Host String - Confused!!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 01 20:45:20 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.