As we know all that in the world of technology we have to fill ups user and password name multiple times . We must know what is actually happens while we enter incorrect password. First few lines give some basic idea about the Authentication.
Authentication is a process in which the credentials provided are compared to those on file in a database of authorized users’ information on a local operating system or within an authentication server.
Different systems may require different types of credentials to ascertain a user’s identity. The credential often takes the form of a password, which is a secret and known only to the individual and the system. Three categories in which someone may be authenticated are: something the user knows, something the user is, and something the user has.
We are going to have look on the procedure to Determine the process which is locking an Oracle account with incorrect password, which search from the dba_audit_session view for records with a return code equal to 1017 which indicate a failed logon.
column username format a15 column userhost format a25 column terminal format a15 column timestamp format a15 column action_name format a15 select username, userhost, terminal, timestamp, action_name from sys.dba_audit_trail where RETURNCODE='1017'; USERNAME USERHOST TERMINAL TIMESTAMP ACTION_NAME --------------- ------------------------- ---------- ----------- ----------- appsread <HOSTNAME> 02-APR-14 LOGON appsread <HOSTNAME> 02-APR-14 LOGON appsread <HOSTNAME> 02-APR-14 LOGON appsread <HOSTNAME> 02-APR-14 LOGON appsread <HOSTNAME> 02-APR-14 LOGON
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
