Home » RDBMS Server » Server Administration » 07_dictionary_accessibility
07_dictionary_accessibility [message #261059] Tue, 21 August 2007 12:35 Go to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
I have changed the 07_dictionary_accessibility parameter to false however I am still able to login as follows

sqlplus /as sysdba

is there something I am missing?
Re: 07_dictionary_accessibility [message #261061 is a reply to message #261059] Tue, 21 August 2007 12:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

07_dictionary_accessibility
It is not related to authentication method.

and this parameter is desupported.

"conn / as sysdba"

trun off NTS to NONE in sqlnet.ora file.
or
Remove OS user from ORA_DBA group.


Regards
Taj
Re: 07_dictionary_accessibility [message #261067 is a reply to message #261059] Tue, 21 August 2007 13:06 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
setting 07_dictionary_accessibility to false prevent user having "ANY" privilege from accessing SYS objects.
For instance, those with "SELECT ANY TABLE" can't select SYS tables.

Regards
Michel
Previous Topic: Database not opening,error "Block Size small"
Next Topic: LRM-00109
Goto Forum:
  


Current Time: Sun Dec 04 10:22:19 CST 2016

Total time taken to generate the page: 0.17409 seconds