PL/SQL (MOSC)

MOSC Banner

Audit Database Login and Loogout

edited Jan 30, 2012 2:54AM in PL/SQL (MOSC) 8 comments
I work on oracle 9.2.0.4

I created a table called t_audit (oper_type varchar2(50), username archar2(50), machine_id varchar2(50), oper_date date)

to store in it all the operations worked on the database like  login, logout, open db, shutdown

how can I create a trigger on the database level to fill the table t_audit  with the required data.

Thanks in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center