OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » User Role (9i)

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

User Role [message #391386]

Thu, 12 March 2009 01:01

beetel
Messages: 96
Registered: April 2007

Member

I find dba_roles, but I dont see any user_roles table. Is there a way I can find the roles created by a user??

Report message to a moderator

Re: User Role [message #391392 is a reply to message #391386]

Thu, 12 March 2009 01:30

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Is there a way I can find the roles created by a user??

No. This information is not kept. SYS "owns" the roles.

Regards
Michel

Report message to a moderator

Re: User Role [message #391430 is a reply to message #391392]

Thu, 12 March 2009 04:31

beetel
Messages: 96
Registered: April 2007

Member

In that case, how do I find what are the user-defined roles??

Report message to a moderator

Re: User Role [message #391433 is a reply to message #391430]

Thu, 12 March 2009 04:39

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no user-defined roles.
What do you mean by this?
Roles are database wide.

Regards
Michel

[Updated on: Thu, 12 March 2009 04:40]

Report message to a moderator

Re: User Role [message #391568 is a reply to message #391386]

Thu, 12 March 2009 10:43

dba-assist
Messages: 3
Registered: November 2008

Junior Member

[deleted] will tell you who created what roles and what privileges were assigned

[Updated on: Thu, 12 March 2009 12:59] by Moderator

Report message to a moderator

Re: User Role [message #391585 is a reply to message #391568]

Thu, 12 March 2009 11:33

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is plain wrong!

STOP SPAMMING ALL TOPICS WITH YOUR USELESS TOOL.

Regards
Michel

[Updated on: Thu, 12 March 2009 11:34]

Report message to a moderator

Re: User Role [message #391629 is a reply to message #391585]

Thu, 12 March 2009 14:19

beetel
Messages: 96
Registered: April 2007

Member

Hi Michel,
What I mean is if a user (which has a CREATE ROLE privilege) has defined some roles, say Role1 and Role2, how will I be able to know (say I am another user) which ones are by default system-defined and which ones are created by other users.
I hope am clear..
Thanks.

Report message to a moderator

Re: User Role [message #391634 is a reply to message #391629]

Thu, 12 March 2009 14:37

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

A role is not owned by anybody.
Once created it is available for everybody (means a DBA can grant it to anybody).
You can't know who creates it.
There is no notion of system-created or user-created roles in the database.

Regards
Michel

Report message to a moderator

Re: User Role [message #391636 is a reply to message #391386]

Thu, 12 March 2009 14:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

"system" or "default" ROLEs change across different versions of Oracle software

Report message to a moderator

Previous Topic:	need help to get space from tablespace
Next Topic:	Replication on database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 03:47:11 CDT 2024