See attachment (What is the syntax for setting up Oracle proxy authentication in TOAD.docx) for graphics.
RESOLUTION 1:
Create a Proxy User that uses DANNY via script:
--Here is the SQL to create the Proxy User.
CREATE USER PROXY_USER
IDENTIFIED BY VALUES 'set_password_here'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 3 System Privileges for PROXY_USER
GRANT ADVISOR TO PROXY_USER;
GRANT CREATE SESSION TO PROXY_USER;
GRANT CREATE TABLE TO PROXY_USER;
-- 1 Tablespace Quota for PROXY_USER
ALTER USER PROXY_USER QUOTA UNLIMITED ON USERS;
-- Here is the statement to grant connection through the Danny user to the Proxy User.
ALTER USER DANNY
GRANT CONNECT THROUGH PROXY_USER;
RESOLUTION 2:
1. Create a Proxy User (Proxy_User) via Toad for Oracle's Schema Browser | Create User.
2. In the Schema Browser, select the user (Danny) that the Proxy User will have connection through and click the Alter User button.
3. Click on Proxies tab, for the Danny user.
3. Click on Add button to select the Proxy User (
Proxy_User).
4. One can see SQL generated by clicking Show SQL button.
LOGGING IN:
Using the information from Resolution1:
Login would proxy_user[DANNY}/proxy_users_password