? Oracle View user logon failures and details

Oracle View user logon failures and details

First, the specific steps

View user Information

To view the policy for the default profile

To view the number of failed Xysoul user logins

Select Lcount from user$ where name= ' DPM ';

Turn on auditing and view audit information below

-View current Audit information

Set Lines 200

Col Userhost for A20

Col Comment$text for A30

Col SPARE1 for A20

Col ntimestamp# for A35

Select Sessionid,userid,userhost,comment$text,spare1,to_char (NTIMESTAMP#+1/3, ' Yyyy-mm-dd hh24:mi:ss ') from aud$

where returncode=1017 order by ntimestamp# Desc;

View audit information by connecting to a tool such as PL/SQL, as shown below, aud$ view can find out the time of login failure, client and other information,

[Email protected]> Select Sessionid,userid,userhost,comment$text,spare1,to_char (NTIMESTAMP#+1/3, ' yyyy-mm-dd Hh24:mi:ss ') from the aud$ where returncode=1017 order by ntimestamp# Desc;

Three, Summary:

Through the above test, we found that several views are not our common view, and not very good to find the role of the columns in the view, the above view information in the script sql.bsq, because the oracle11g script is more detailed, you can simply spell the view.

? Oracle View user logon failures and details