ORA-28058: login is allowed only through a proxy

Toad for Oracle
1

Hi

I am unable to logon to the database as proxy dba from TOAD, but I can login using the SQLPLUS (with 12c client).

Below are the details of the SQLPLUS connection which allows SCOTT to connect as proxy dba.

$ sqlplus scott[pdbdba]@orcl

SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 1 06:05:00 2016

Copyright © 1982, 2014, Oracle. All rights reserved.

Enter password:
Last Successful login time: Thu Sep 01 2016 06:03:35 +01:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options

SQL>

Below are the details of the TOAD connection which is failing to connect SCOTT as proxy dba.

TOAD Version 11.6.0.43

Oracle DB version 12.1.0.2

Oracle Client version 11gR2

Note that, I can successfully login via TOAD as scott (normal user) but not as scott[pdbdba] , it returns the following error ORA-28058: login is allowed only through a proxy

Please advise the way forward. TIA.

2

Toad supports proxy logins. It should work.

However, in Toad 11.6, Toad actually makes two sessions to perform the proxy connection. So both SCOTT and PDBDBA need the CREATE SESSION privilege.

Starting with Toad 12.5, it’s more of a true proxy connection, with only one session. So if granting CREATE SESSION to both users is not an option for you, then upgrade your Toad.