OraFAQ Forum: Security » Creating Before On logon Trigger in Oracle

Home » RDBMS Server » Security » Creating Before On logon Trigger in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating Before On logon Trigger in Oracle [message #164890]

Mon, 27 March 2006 05:54

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

---

Report message to a moderator

Re: Creating Before On logon Trigger in Oracle [message #167924 is a reply to message #164890]

Mon, 17 April 2006 22:59

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;

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 22 19:16:22 CDT 2026