Oracle Database Proxy Authenticated Connections

Not sure how long this has been available but we like this at work.

On an Oracle 12c database, login as sys as sysdba.

Create two users:

create user James identified by James;
create user Ben identified by Ben;
grant create session to James;
grant create session to Ben; 

Now grant Ben the ability to connect through to James:

alter user James grant connect through Ben;

Now you are able to connect as Ben without knowing his password.

connect Ben[James]/Ben

show user
USER is "JAMES"

So you can see that even though we are logging in as Ben, using the [] brackets we are actually logging in as James;