Home » RDBMS Server » Security » sysdba login (oracle 10g ,Linux AS4)
sysdba login [message #313434] Sat, 12 April 2008 02:01 Go to next message
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
Re: sysdba login [message #313435 is a reply to message #313434] Sat, 12 April 2008 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove the users from the dba group.

Regards
Michel
Re: sysdba login [message #313436 is a reply to message #313435] Sat, 12 April 2008 02:10 Go to previous messageGo to next message
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
Re: sysdba login [message #313437 is a reply to message #313436] Sat, 12 April 2008 02:54 Go to previous messageGo to next message
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
Re: sysdba login [message #313440 is a reply to message #313437] Sat, 12 April 2008 03:36 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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
Re: sysdba login [message #313444 is a reply to message #313441] Sat, 12 April 2008 04:07 Go to previous messageGo to next message
airother
Messages: 27
Registered: February 2006
Junior Member
Then what is a use of password entry in password file?
Re: sysdba login [message #313446 is a reply to message #313444] Sat, 12 April 2008 07:34 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you want to ensure the password file is used by EVERYONE including the users in the O/S dba group, set the following in your sqlnet.ora file:

sqlnet.authentication_services=NONE
Re: sysdba login [message #313460 is a reply to message #313444] Sat, 12 April 2008 10:29 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Then what is a use of password entry in password file?

It is the password of SYS (as I said).
connect sys/<password file password> as sysdba
connect test/<test password> as sysdba

Regards
Michel
Previous Topic: user expired
Next Topic: insufficient privelege
Goto Forum:
  


Current Time: Thu Mar 28 06:30:38 CDT 2024