Database Administration (MOSC)

MOSC Banner

Can I Track SQL*Plus users

Is there a database trigger or can I create one that fires "after logon"? I'll need it to looks at the v$session and inserts into my custom table, any time a user is using SQL*Plus, SQL Developer, or any other program that needs specific permissions?

Obviously I'd want the USERNAME, OS_USER, MODULE, MACHINE, and LOGON_TIME.

I'd rather not use auditing, because throwing it in a db table and running queries on it seems a lot easier to me.

I suspect at least one user has the knowledge to get directly into the db and run dml outside of the applications they should be using.

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