oracle - Is it possible to use the Proxy authentication toward an External authenticated user? -


Suppose i have three users a, b, c, three of them are defined as external authentication (Three OS users are the same machine)

Now think about the WS, which usually receives the user / password information from the customer (where A, B, and C are) and connect to the cloning database of A, B and C. . What will not work in this scenario, because WS is on another machine, and can not provide passwords for A, B and C DB connections.

I was thinking about making a user D, the external is not certified, and D to gran Proxy Authentication so that he could be able to connect as A, B and C. Will he work?

Do I just need to run the following?

  ALTER USER D Connect a change via user D permit Connect the user D permutation through B. C  

and I connect to WS How do I apply? Do I need to feed usernames?

It is possible to turn, but this should be the second way to get out. You can change user A, B, C to join D, which will allow you to connect to a user name as D.

The only thing to remember is that the OS certified user name is OSP $ USERNAME


Comments

Popular posts from this blog

java - Can't add JTree to JPanel of a JInternalFrame -

javascript - data.match(var) not working it seems -

javascript - How can I pause a jQuery .each() loop, while waiting for user input? -