| OPS$ [message #235787] |
Tue, 08 May 2007 00:41  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
hello all,pls see the following scenario .
SQL> select granted_role from dba_role_privs
2 where grantee='OPS$ORACLE';
GRANTED_ROLE
------------------------------
CONNECT
DBA
RESOURCE
SQL> select password from dba_users
2 where username='OPS$ORACLE';
PASSWORD
------------------------------
EXTERNAL
oracle@gbo885d:/home/oracle> whoami
oracle
Why it fails ?
SQL> conn /
ERROR:
ORA-01017: invalid username/password; logon denied
note :user ORACLE is part of unix DBA group
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
