CODEWITHSUNDEEP
sqloracle-databaselogging
Ajay Gupta
Ajay Gupta

Reputation: 157

oracle log path for invalid user

When login credentials fail, Oracle gives an error in SQL terminal :

invalid username/password; logon denied

I need help to know where does Oracle keep this log. I need this log to generate suspicious login.

Upvotes: 0

Views: 223

Answers (1)

GMB
GMB

Reputation: 222472

Oracle provides a built-in functionality to track failed logins as part of the standard audit trail.

Once the audit trail is enabled, the following command can be used to turn on auditing of failed logins (it needs to be executed as SYSDBA) :

audit create session whenever not successful;

Failed logins will be reported in table dba_audit_trail.

Upvotes: 2

Related Questions