| System Privileges [message #471940] |
Wed, 18 August 2010 00:32  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi,
please help me on the below, which confusing me a bit.
Q1:
Is the role SELECT/EXECUTE/DELETE_CATALOG_ROLE is dependent on the setting of 07_DICTIONARY_ACCESSIBILITY=FALSE?
Q2:
please explain conn /as sysdba. I know sysdba is a powerful system Privilege. But tell me about it and can we use SYSOPER for instead of it....
Thanks in advance
|
|
|
|
|
|
|
|
| Re: System Privileges [message #472097 is a reply to message #471964] |
Wed, 18 August 2010 15:36  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi Mickel,
Q1:
Actually to protect the sys schema we need to set 07_DICTIONARY_ACCESSIBILITY=FALSE
At this mode, can we use create/delete.... CATALOG_ROLE?
Thanks a lot
|
|
|
|
|
|
| Re: System Privileges [message #472165 is a reply to message #472138] |
Thu, 19 August 2010 03:23 |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi Mickel,
I'm really sorry to make u clear,
My point was, to protect the sys schema from unwanted users, we need to set the init parameter 07_DICTIONARY_ACCESSIBILITY,
Which is default with FALSE, assigning the role CATALOG_ROLE will affect the sys schema or not, if we set the init parameter 07_DICTIONARY_ACCESSIBILITY =TRUE?
Thanks
|
|
|
|
|
|
| Re: System Privileges [message #472280 is a reply to message #472165] |
Thu, 19 August 2010 12:57 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
muktha_22 wrote on Thu, 19 August 2010 04:23
My point was, to protect the sys schema from unwanted users
Maybe I am missing the point here, but wouldn't the solution be to not give out the SYS schema password to users?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
