Home » RDBMS Server » Security » OPS$
OPS$ [message #235787] Tue, 08 May 2007 00:41 Go to next message
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
Re: OPS$ [message #235794 is a reply to message #235787] Tue, 08 May 2007 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ >200 posts and still don't know YOU HAVE TO FORMAT YOUR POST
2/ >200 posts and still don't know YOU HAVE TO POST YOUR ORACLE VERSION
3/ What is the value of parameter os_authent_prefix?

Regards
Michel
Re: OPS$ [message #235803 is a reply to message #235787] Tue, 08 May 2007 01:14 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Gocha!
os_authent_prefix was set to none.
Previous Topic: conn as SYSDBA
Next Topic: for creating table in new user
Goto Forum:
  


Current Time: Thu Mar 28 19:39:42 CDT 2024