Home » RDBMS Server » Server Administration » alter sysdba login
alter sysdba login [message #294832] Sat, 19 January 2008 21:21 Go to next message
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 #294833 is a reply to message #294832] Sat, 19 January 2008 21:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Remove the user from OSDBA group that you use in log in.
Re: alter sysdba login [message #294835 is a reply to message #294833] Sat, 19 January 2008 22:34 Go to previous messageGo to next message
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
Re: alter sysdba login [message #294836 is a reply to message #294832] Sat, 19 January 2008 23:00 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member
My Dear Das ji, SYSDBA is a system privilege & DBA is a role, now you decide what you want to give to your users and also have a look on docs.

Regards

Manjit Kumar [mkbhati]

[Updated on: Sat, 19 January 2008 23:02]

Report message to a moderator

Re: alter sysdba login [message #294837 is a reply to message #294832] Sat, 19 January 2008 23:28 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
Can you tell me how to do that?


Using OS remove groups from the user, Unix and Windows has different system.
Previous Topic: ORA-1110 and ORA-1122 when trying startup upgrade
Next Topic: connection to remote server as sysdba
Goto Forum:
  


Current Time: Wed Dec 07 18:54:57 CST 2016

Total time taken to generate the page: 0.08881 seconds