Tuesday, 26 February 2019

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
So you can see that even though we are logging in as Ben, using the [] brackets we are actually logging in as James;

Oracle CPU downloader

Every quarter I have to go through and download numerous patches for the Oracle CPU (Critical Patch Update). You have to view the CPU docume...