Home » RDBMS Server » Security » roles
roles [message #3738] Tue, 15 October 2002 18:26 Go to next message
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?
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
Previous Topic: Hiding passwords
Next Topic: how to enable the auditing in oracel 8.0.5
Goto Forum:

Current Time: Thu May 26 02:48:46 CDT 2022