Home » RDBMS Server » Security » Role
Role [message #276328] Wed, 24 October 2007 21:17 Go to next message
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

Hello Sir,
Good Morning,
Creator of role gets which privilege by default with restect to the he has just created

Thanks in advance
Re: Role [message #276330 is a reply to message #276328] Wed, 24 October 2007 21:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Creator of role gets which privilege by default with restect to the he has just created
HUH?

SQL> CREATE ROLE ANY_UNIQUE_NAME;
As Far As I Know (AFAIK) the USER which issued the SQL above gets no (new) privilege just because this new ROLE got created.

By the way, the sun set here about 1 hour ago so it is not exactly morning for me.

[Updated on: Wed, 24 October 2007 21:29] by Moderator

Report message to a moderator

Re: Role [message #276331 is a reply to message #276330] Wed, 24 October 2007 21:32 Go to previous messageGo to next message
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

Sir i want to know which administrative previlege does he get either 'with grant option' or 'with admin option'
Re: Role [message #276332 is a reply to message #276328] Wed, 24 October 2007 21:38 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you are capable & willing to Read The Fine Manual,
I am sure you can find the answer to your question.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6012.htm#sthref7217
Previous Topic: create sequence privileges
Next Topic: Password
Goto Forum:
  


Current Time: Thu Mar 28 18:45:12 CDT 2024