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.