Home » RDBMS Server » Security » roles
roles [message #3738] Tue, 15 October 2002 18:26 Go to next message
tiger
Messages: 11
Registered: August 2002
Junior Member
I want to get all roles granted to a user including roles granted through other roles.
For example:
I have two roles:r1 & r2 and an user: u1.
I granted r2 to r1 and granted r1 to u1.
I hope to know there are two roles:r1 & r1 granted to u1.
How can I write the sql?

Report message to a moderator

Re: roles [message #3756 is a reply to message #3738] Wed, 16 October 2002 12:09 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:853427230099

Report message to a moderator

Previous Topic: Hiding passwords
Next Topic: how to enable the auditing in oracel 8.0.5
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 19:19:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.