Monthly Archives: July 2018

Oracle Proxy user example

Posted on July 12, 2018 by myother

As sys/system user: ALTER USER schema_owner grant CONNECT THROUGH test_user_rw; SELECT * FROM proxy_users; In another session: CONN test_user_rw[schema_owner]/test_user_password@database697 show user USER is “schema_owner” https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:5640055700346730346  

Posted in Oracle, Uncategorized | Leave a comment