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?
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;
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
Previous Topic: URGENT - Grant DBA PRIVS TO USER
Next Topic: What is my UserName, Password and Host String - Confused!!!
Goto Forum:
  


Current Time: Tue Oct 26 06:48:11 CDT 2021