OraFAQ Forum: Security » sysdba login

Home » RDBMS Server » Security » sysdba login (oracle 10g ,Linux AS4)

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

sysdba login [message #313434]

Sat, 12 April 2008 02:01

airother
Messages: 27
Registered: February 2006

Junior Member

Hi,
In my init.ora file i set remote_login_passwordfile=EXCLUSIVE
and i create orapwd file.
when is connect though sqlplus / as sysdba
it is connected.
How should i stop this .
It should use password file password entry,while connect to database through sysdba.

Thanks in advance

Ajit

Report message to a moderator

Re: sysdba login [message #313435 is a reply to message #313434]

Sat, 12 April 2008 02:05

Michel Cadot
Messages: 68453
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remove the users from the dba group.

Regards
Michel

Report message to a moderator

Re: sysdba login [message #313436 is a reply to message #313435]

Sat, 12 April 2008 02:10

airother
Messages: 27
Registered: February 2006

Junior Member

Hi,
i can able to connect by any user even that on not exist in database
sqlplus xyz/123 as sysdba
it also work ,no xyz user in our database

Regards
Ajit

Report message to a moderator

Re: sysdba login [message #313437 is a reply to message #313436]

Sat, 12 April 2008 02:54

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Quote:

Remove the users from the dba group.

i.e. remove the OS users from the dba group on the o/s

Report message to a moderator

Re: sysdba login [message #313440 is a reply to message #313437]

Sat, 12 April 2008 03:36

airother
Messages: 27
Registered: February 2006

Junior Member

Thanx, its work
But still other than sys user can connect to database( as sysdba) ,with their password and not using password file entry password
e.g
my password file as entry orapwd file=$HOME_ORACLE/dbs/orapworcl password=pass entries=5

I connect as sys give grant sysdba to other database user
sqlplus sys/pass as sysdba
connect
>grant sysdba to test
test user having password test
when connect as test
sqlplus test/test as sysdba it is connecting,but when is trying
sqlplus test/pass as sysdba it is giving Insufficent privilege
please explain

Regards,
Ajit

[Updated on: Sat, 12 April 2008 03:37]

Report message to a moderator

Re: sysdba login [message #313441 is a reply to message #313440]

Sat, 12 April 2008 03:55

Michel Cadot
Messages: 68453
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Of course, each user with sysdba privilege use his password and this password is recorded in password file.
Password file password is SYS password.

Regards
Michel

Report message to a moderator