OraFAQ Forum: Server Administration » 07_dictionary

Home » RDBMS Server » Server Administration » 07_dictionary_accessibility

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

07_dictionary_accessibility [message #261059]

Tue, 21 August 2007 12:35

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?

Report message to a moderator

Re: 07_dictionary_accessibility [message #261061 is a reply to message #261059]

Tue, 21 August 2007 12:39

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

Report message to a moderator

Re: 07_dictionary_accessibility [message #261067 is a reply to message #261059]

Tue, 21 August 2007 13:06

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:27:47 CDT 2024