Home » RDBMS Server » Security » conn as SYSDBA
conn as SYSDBA [message #235775] Tue, 08 May 2007 00:13 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
hi,
first i connected as / as sysdba
then i created another user

create user oradba identified by password;
grant connect,resource,create session to oradba;
grant dba to oradba;

then i connected as conn oradba/password as sysdba .

it connected !! i didnt grant SYSDBA privilege to oradba user,still i connected.Can someone explain me how
Re: conn as SYSDBA [message #235782 is a reply to message #235775] Tue, 08 May 2007 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Dont' use connect, resource roles they are obsolete
2/ Avoid use of DBA role, create your own "dba" role
3/ Don't use SYS for anything but dbatabase maintenance purpose (startup, shutdown, restore)
4/ It connects as sysdba only because you are in OS dba group (often "dba" in Unix and ORA_DBA or ORA_<SID>_DBA in Windows)

Regards
Michel
Re: conn as SYSDBA [message #235786 is a reply to message #235775] Tue, 08 May 2007 00:39 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thnx mike .

>>Dont' use connect, resource roles they are obsolete
instead of that, what we can use in future versions ?
Re: conn as SYSDBA [message #235796 is a reply to message #235786] Tue, 08 May 2007 01:03 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create your roles then you know what is inside and that fit your requirements.

Regards
Michel
Previous Topic: how to know who disable a trigger
Next Topic: OPS$
Goto Forum:
  


Current Time: Thu Mar 28 10:58:03 CDT 2024