Home » RDBMS Server » Server Administration » conn / as sysdba
conn / as sysdba [message #223211] Thu, 08 March 2007 00:41 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi ,Now i do connect to my local database as
conn / as sysdba.

Any ways to stop this so that i always need to enter password for DB conenction ?
I set remote_login_passwordfile = none.Still it let me connect / as sysdba.

thnx
Rajiv

Report message to a moderator

Re: conn / as sysdba [message #223219 is a reply to message #223211] Thu, 08 March 2007 00:50 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
If your user(s) belong to the "dba" group on Unix, or the "ORA_DBA" group on windows. They all will be able to "connect / as sysdba"
without being prompt for a password.

Report message to a moderator

Re: conn / as sysdba [message #223221 is a reply to message #223219] Thu, 08 March 2007 00:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,

conn / as sysdba.
We can connect without password as sysdba when OS user member of OS_DBA group ( tahpush already mention) and sqlnet.authentication_services = NTS.

for prevent this you should change sqlnet.ora file from NTS to NONE.



remote_login_passwordfile
http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams176.htm


regards
Taj

Report message to a moderator

Re: conn / as sysdba [message #223222 is a reply to message #223211] Thu, 08 March 2007 00:59 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
tahpush,
Thnx, yes.i found a admin group was created while installing Oracle (ORA_DBA) and group description says "Members can connect to the Oracle database as a DBA without a password" .

Report message to a moderator

Previous Topic: ORA 7445 exception encountered
Next Topic: Installation Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:40:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.