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''