Home » RDBMS Server » Server Administration » How to know which role I was granted?
How to know which role I was granted? [message #53527] Wed, 25 September 2002 14:13 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 #53532 is a reply to message #53527] Wed, 25 September 2002 20:21 Go to previous messageGo to next message
puneet
Messages: 76
Registered: August 2002
Member
select * from user_role_privs

Report message to a moderator

Re: How to know which role I was granted? [message #53545 is a reply to message #53527] Thu, 26 September 2002 04:05 Go to previous message
Bachi
Messages: 13
Registered: September 2002
Junior Member
CONNECT TO UR SCHEMA AND JUST VIEW SESSION_ROLES
THEN U GET THE CORRESPONDING ROLES..
SIMILARY FOR SESSION_PRIVS.

Report message to a moderator

Previous Topic: ORA-00600: internal error code, arguments: [17033], [509], [128], [], [], [], [], []
Next Topic: Re: ORA-12514: tns:LISTENER COULD NOT RESOLVE service_name GIVEN IN CONNECT DESCRIPTOR
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 11 08:36:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.