Oracle Scripts

Oracle Database yetkisiz erişim sağlayan kullanıcılar

Oracle Database üzerinde hatalı şifre giriş yapan yada kilitli bir hesaba giriş yapmak isteyen kullanıcıları nasıl listeleyebilirim ?

  SELECT username                                 AS "DB KULLANICI",
         os_username                              AS "OS KULLANICI",
         userhost                                 AS "HOSTNAME",
         TO_CHAR (timestamp, 'DD/MM/YY HH24:MI:SS')"TIMESTAMP",
         DECODE (
             returncode,
             01017, 'HATALI KULLANICI YADA SIFRE',
             28000, 'KILITLI HESAP DENEMESI')
             AS returncode
    FROM SYS.DBA_AUDIT_SESSION
   WHERE returncode != 0 AND returncode IN (1017, 28000)
ORDER BY extended_timestamp DESC
Tags

Bugra Parlayan

I use this blog in my spare time to jot down thoughts and share my professional experiences. It’s my personal space to unwind and reflect. Feel free to share or reuse anything you find helpful here — just a small thank you is more than enough :) You can reach me at: bugra[@]bugraparlayan.com.tr

Related Articles

Leave a Reply

Back to top button
Close