|
-
If the user is created with external identification then he can't be granted with sysdba privileges.But if the user is created with password then he can connect as sysdba and can use '/'.
SQL> create user ops$abc identified by abc;
User created.
SVRMGR> grant sysdba to ops$abc;
Statement processed.
SVRMGR> connect / as sysdba;
Connected.
SVRMGR> connect /
ORA-01045: user OPS$abc lacks CREATE SESSION privilege; logon denied
SVRMGR> connect internal
Connected.
SVRMGR> grant create session to ops$abc;
Statement processed.
SVRMGR> connect /
Connected.
SVRMGR> connect / as sysdba;
Connected.
one more point is take care that the parameter
SQLNET.AUTHENTICATION_SERVICES= (NTS) in SQLNET.ORA is not commented out or 'NTS' is not replaced with NONE.
Last edited by akhadar; 04-15-2003 at 01:02 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote