proxy user - login issue [message #633986] |
Mon, 02 March 2015 05:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/cec1cd3fe42eabf623403a4f2eae9948?s=64&d=mm&r=g) |
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
|
|
|
|
|