Home » RDBMS Server » Server Administration » User Role (9i)
User Role [message #391386] Thu, 12 March 2009 01:01 Go to next message
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??
Re: User Role [message #391392 is a reply to message #391386] Thu, 12 March 2009 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: User Role [message #391430 is a reply to message #391392] Thu, 12 March 2009 04:31 Go to previous messageGo to next message
beetel
Messages: 96
Registered: April 2007
Member
In that case, how do I find what are the user-defined roles??
Re: User Role [message #391433 is a reply to message #391430] Thu, 12 March 2009 04:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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 Go to previous messageGo to next message
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.
Re: User Role [message #391634 is a reply to message #391629] Thu, 12 March 2009 14:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: User Role [message #391636 is a reply to message #391386] Thu, 12 March 2009 14:40 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
"system" or "default" ROLEs change across different versions of Oracle software
Previous Topic: need help to get space from tablespace
Next Topic: Replication on database
Goto Forum:
  


Current Time: Sat Dec 03 10:04:38 CST 2016

Total time taken to generate the page: 0.13391 seconds