advertisements
_____________________________________________________________________________________________________________________
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…
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.
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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment