GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
Database Security - General
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Aug 31, 2012 12:16 PM by BSalesRashid
Audit connect - Audit_trail=OS
Aug 31, 2012 12:16 PM
Currently Being Moderated
I am have some trouble with an user that is locking his own account, several times a day:
I changed his profile to put the wrong password 10 times, up from 5, and it keeps locking.
But here's the deal:
This user is from an application, and the 2 developers have the access. They couldn't find the class that is failing with the password.
I looked for something on google and then i saw that would be better to audit and check it. Well, i did. I changed the parameter
, and also
audit connect whenever NOT successful;
Fine, now i made myself a test. Tried to connect with my own user, missing the password, and it gives:
SESSIONID: "3353991" ENTRYID: "1" STATEMENT: "1" USERID: "BRUNOS" USERHOST: "FASTSOLUTIONS\PRO_TEC_EST_049" TERMINAL: "PRO_TEC_EST_049" ACTION: "100" RETURNCODE: "1017" COMMENT$TEXT: "Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.34.199)(PORT=64229))" OS$USERID: "brunos" DBID: "1339862449"
I did also: brunos@rac_cmspw1> select * from audit_actions where action=3;
How could i have done a SELECT statement if i don't even connected at the base ?
The reason i open this thread, is that i need some help to interpret this log.
Any help would be apreciated.
Thanks in advance.
Edited by: BSalesRashid on 31/08/2012 12:16
Track in Communications
- 10 points
- 5 points