Home » RDBMS Server » Security » Creating Before On logon Trigger in Oracle
Creating Before On logon Trigger in Oracle [message #164890] Mon, 27 March 2006 05:54 Go to next message
devathi80
Messages: 5
Registered: September 2005
Location: Chennai
Junior Member

Hi All,

I am having one Database user Account called dba.

This dba account has been "locked" several times over the last couple of days and this is the account i use normally.

Now, that it is being "locked" so often I must sign on as privilaged user "SYS" to unlock it.

Please help me/Suggest me that how can I find out who is trying to use this account with the incorrect password causing it to be locked.

Some of my friends suggested to have Before On-logon trigger which solves the solution.

I need some more suggestions for this issue.

Thanks,
Manoj Kumar

---

Re: Creating Before On logon Trigger in Oracle [message #167924 is a reply to message #164890] Mon, 17 April 2006 22:59 Go to previous message
markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada
Senior Member
there is no "before logon" trigger exist.
Obviously that "after logon" trigger will not help you because it will not be fired when wrong password entered.

AUDIT can help you.
conn / as sysdba
alter system set audit_trail=db scope=spfile;
shutdown immediate
startup

AUDIT CREATE SESSION;

exit


....
wait Cool
....

select *
from dba_audit_session
where returncode<>0;



Previous Topic: sys and system
Next Topic: oracle security settings and acess limits.
Goto Forum:
  


Current Time: Fri Mar 29 01:32:36 CDT 2024