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''
… [Trackback]
[…] There you will find 2374 more Information on that Topic: techdatabasket.com/2015/04/09/connect-user-using-grant-connect-through/ […]
… [Trackback]
[…] Find More Information here on that Topic: techdatabasket.com/2015/04/09/connect-user-using-grant-connect-through/ […]