Oracle Database has a grant that you can use to connect through another user. For example, I have the use ”A” and I want to connect with this user through the user ”brunors”. It possible to do it, but you need to give the grant connect through to user ”brunors”. I am going to show how it works now..
Let’s go…
SQL> create user brunors identified by <brunors’s password here>;
User created.
SQL> grant connect , resource , create session to brunors;
Grant succeeded.
SQL> ALTER USER A GRANT CONNECT THROUGH brunors;
User altered.
SQL> conn brunors[A]
Enter password:
Connected.
SQL> show user
USER is ”A”
