CONNECT USER USING GRANT CONNECT THROUGH

oracle-11g-logo

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

icon2

Related posts

Leave a Comment