Home » RDBMS Server » Security » proxy user - login issue (11gR2 )
proxy user - login issue [message #633986] Mon, 02 March 2015 05:31 Go to next message
candi
Messages: 39
Registered: July 2012
Member
Hi,

I am trying to set up a proxy user and I am getting a login validation error. Set up described below:


SQL> create user proxyone identified by proxy1;

User created.

SQL> grant create session to proxyone;

Grant succeeded.


SQL> alter user proxyone grant connect through act1;

User altered.

SQL> alter user proxyone quota unlimited on users;

User altered.

SQL> connect proxyone[act1]/proxy1
ERROR:
ORA-01017: invalid username/password; logon denied







Re: proxy user - login issue [message #633988 is a reply to message #633986] Mon, 02 March 2015 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 67366
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The third statement is wrong (see the last but one below), it is the opposite:
SQL> create user act1 identified by act1;

User created.

SQL> grant create session to act1;

Grant succeeded.

SQL> create user proxyone identified by proxy1;

User created.

SQL> grant create session to proxyone;

Grant succeeded.

SQL> alter user act1 grant connect through proxyone ;

User altered.

SQL> connect proxyone[act1]/proxy1
Connected.
SQL> show user
USER is "ACT1"

Re: proxy user - login issue [message #633995 is a reply to message #633986] Mon, 02 March 2015 07:06 Go to previous message
candi
Messages: 39
Registered: July 2012
Member
thanks
Previous Topic: ACL
Next Topic: proxy users - DBA_AUDIT_TRAIL
Goto Forum:
  


Current Time: Tue Sep 22 13:29:55 CDT 2020