alter sysdba login [message #294832] |
Sat, 19 January 2008 21:21  |
durgadas.menon
Messages: 365 Registered: December 2007 Location: Nowhere
|
Senior Member |
|
|
guys,
I want to change the password of sysdba login so that no one can access the system schema except me.
after opening the database I passed this command
alter user sys identified by sys;
it ran successfully but I restarted oracle I was able to enter the system schema by passing this command /as sysdba. Now this login command is common and anyone with a little knowledge could login in the system schema. How to get around this?
Thanks
- Das
|
|
|
|
Re: alter sysdba login [message #294835 is a reply to message #294833] |
Sat, 19 January 2008 22:34   |
durgadas.menon
Messages: 365 Registered: December 2007 Location: Nowhere
|
Senior Member |
|
|
Thanks a lot
Can you tell me how to do that? i.e. remove the user from the OSDBA group..
I tried the following as a way around
create user das identified as das;
grant sysdba to das;
then I shutdown the system and started it with das/das and it says oracle not available...this means oracle is taking das as a user not sysdba...but I did grant das the sysdba role...what is the reason for this?
- Das
|
|
|
|
|