Connect Through a Proxy User Account

If you have required privileges, it’s possible to connect as a user account without knowing or changing his password. This is called proxy connection. To authorize a user account to connect using a proxy account, use the GRANT CONNECT THROUGH clause of the ALTER USER statement.

Let’s set say we don’t know password of SCOTT user. I connect with my dba account and set “GOKHAN” user as a proxy for SCOTT:

Now we can connect using the GOKHAN proxy user:

Use the REVOKE CONNECT THROUGH clause of ALTER USER to disallow a proxy connection: