| sysdba login [message #313434] |
Sat, 12 April 2008 02:01  |
airother
Messages: 20
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  |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
airother
Messages: 20
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 |
pablolee
Messages: 936
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 |
airother
Messages: 20
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]
|
|
|
| Re: sysdba login [message #313441 is a reply to message #313440 ] |
Sat, 12 April 2008 03:55 |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
airother
Messages: 20
Registered: February 2006 |
Junior Member |
|
|
|
Then what is a use of password entry in password file?
|
|
|
|
| Re: sysdba login [message #313460 is a reply to message #313444 ] |
Sat, 12 April 2008 10:29 |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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
|
|
|
]
Members
Search
Help
Register
Login
Home
