Home » SQL & PL/SQL » SQL & PL/SQL » A question about roles
A question about roles [message #202114] Wed, 08 November 2006 04:13 Go to next message
prince973
Messages: 37
Registered: November 2006
Member
connect sys/change_on_install as sysdba;
grant create role to scott with admin option;

now scott creates some roles maybe he wants to grant this privilege to other users too.

My quesion is
how can the admin (sys) use the dictionary to know the owners of roles , i checked dictinary i didn't find one column refers to the owner of a role, it is not an object too,
pls advise.
Re: A question about roles [message #202126 is a reply to message #202114] Wed, 08 November 2006 05:01 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Roles don't have owners, in the same way that Tablespaces don't have owners.
Re: A question about roles [message #202197 is a reply to message #202114] Wed, 08 November 2006 12:23 Go to previous message
prince973
Messages: 37
Registered: November 2006
Member
Thank you JRowbottom
Previous Topic: ORA-1722 "inavlid number" occured in case of valid number.
Next Topic: need help with script
Goto Forum:
  


Current Time: Tue Dec 06 12:27:00 CST 2016

Total time taken to generate the page: 0.06488 seconds