| conn as SYSDBA [message #235775] |
Tue, 08 May 2007 00:13  |
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 #235786 is a reply to message #235775] |
Tue, 08 May 2007 00:39  |
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 |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Create your roles then you know what is inside and that fit your requirements.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
