ORA-28150: proxy not authorized to connect as client


Error Description:
        User Connection fails with following error.
SQL> conn user2[user1]
Enter password:
ERROR:
ORA-28150: proxy not authorized to connect as client


Solution Description:
Reason 1: When you grant connect through privilege to user if you specify the AUTHENTICATION REQUIRED or AUTHENTICATED USING clause it will throw this error. As per oracle documentation…

AUTHENTICATION REQUIRED Clause
Specify AUTHENTICATION REQUIRED to ensure that authentication credentials for the user must be presented when the user is authenticated through the specified proxy. The credential is a password.
AUTHENTICATED USING
The AUTHENTICATED USING PASSWORD clause has been deprecated for this release. If you use this clause, Oracle Database converts it to the AUTHENTICATIONREQUIRED clause. If you do not specify theAUTHENTICATION REQUIRED clause, then Oracle Database uses either the AUTHENTICATED USINGCERTIFICATE clause or the AUTHENTICATEDUSING DISTINGUISHED NAME clause.
SQL> alter user user1 grant connect through user2 AUTHENTICATION REQUIRED ;

User altered.

SQL> conn user2[user1]
Enter password:
ERROR:
ORA-28150: proxy not authorized to connect as client

Reason 2: You might have revoked the privilege from the user.

SQL> alter user user1 revoke connect through user2;

User altered.

SQL> conn user2[user1]/user2
ERROR:
ORA-28150: proxy not authorized to connect as client


Warning: You are no longer connected to ORACLE.

DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google