Tuesday, September 17, 2024

Logins History of a particular DB user from audit Tables

 SELECT

   distinct(os_username),username,userhost,timestamp

FROM

    sys.dba_audit_session where username in ('<UserName>')


Posted by M A D A N M O H A N at 4:17 PM  

0 Comments:

Post a Comment

Subscribe to: Post Comments (Atom)