OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Role ownership?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Role ownership? [message #161955]

Wed, 08 March 2006 00:43

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Hi all,

Can we get the user that created a role? Or the role does not have any owner.

Thank you.

Report message to a moderator

Re: Role ownership? [message #161962 is a reply to message #161955]

Wed, 08 March 2006 01:01

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Roles are independent to users.
The case belo depicts this point:

Quote:

SQL> create user test123 identified by test123;

User created.

SQL> grant dba to test123;

Grant succeeded.

SQL> conn test123/test123@orcl9i
Connected.
SQL> create role role_test;

Role created.

SQL> select * from dba_roles where role='ROLE_TEST';

ROLE PASSWORD
------------------------------ --------
ROLE_TEST NO

SQL> conn sys/sys@orcl9i as sysdba
Connected.
SQL> drop user test123;

User dropped.

SQL> select * from dba_roles where role='ROLE_TEST';

ROLE PASSWORD
------------------------------ --------
ROLE_TEST NO

SQL> grant role_test to scott;

Grant succeeded.

SQL> revoke role_test from scott;

Revoke succeeded.

SQL>

Yes, a role doesn't have any owner (actually can't find any doc/article/view which tells about ownership of roles.).

--Girish

Report message to a moderator

Re: Role ownership? [message #161971 is a reply to message #161955]

Wed, 08 March 2006 01:16

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Thanks for your reply. Does this means that I would not know a particular role is created by who?

Report message to a moderator

Re: Role ownership? [message #161979 is a reply to message #161971]

Wed, 08 March 2006 01:38

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Enable auditing for the system privilege "CREATE ROLE" & then check auditing information.

Report message to a moderator

Previous Topic:	Tablespace Storage parameters
Next Topic:	9.2.0.7 upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:34:27 CDT 2024