Oracle Scripts
Oracle Database kullanıcı erişim denetimleri
Oracle Database’e erişen kullanıcıların yada erişirken hata alan kullanıcıları nasıl görebilirim ?
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,
00911, 'HATALI KARAKTER GIRISI',
01004, 'GIRIS ENGELLI',
01005, 'BOS SIFRE GIRILDI',
01017, 'HATALI KULLANICI YADA SIFRE',
01031, 'YETKISIZ DENEME',
01045, 'CREATE SESSION YETKISI OLMADAN DENEME',
01918, 'DB OLMAYAN KULLANICI',
01920, 'DB OLMAYAN ROLE',
28000, 'KILITLI HESAP DENEMESI',
28001, 'SIFRE SURESI DOLDU',
28009, 'SYSDBA YADA SYSOPER DENEMESI')
AS returncode
FROM SYS.DBA_AUDIT_SESSION
WHERE returncode != 0 AND -- timestamp > SYSDATE - 1 / 9 -- AND returncode IN (1017, 28000)
ORDER BY extended_timestamp DESC
Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340
Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340
Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114
Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340
Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114