oracle proxy user code example

Example 1: oracle add proxy

-- Grants proxy connection to OTHER_SCHEMA for MY_USER.
-- Connexion User: MY_USER[OTHER_SCHEMA]
ALTER USER OTHER_SCHEMA GRANT CONNECT THROUGH MY_USER;

Example 2: oracle list proxy users

SELECT * FROM PROXY_USERS WHERE PROXY='MY_USER';