我收到EM的警报了。
Host=Teste.com
Target type=Database Instance
Target name=REF.Teste.com
Categories=Security
Message=User SYS logged on from kali.
Severity=Warning
Event reported time=Mar 8, 2017 10:11:04 AM BRT
Target Lifecycle Status=Production
Comment=TI DEV-DV
Operating System=Linux
Platform=x86_64
Event Type=Metric Alert
Event name=UserAudit:username
Metric Group=User Audit
Metric=Audited User
Metric value=SYS
Key Value=SYS_kali
Key Column 1=Audited User - Host
Rule Name=Unavailability,Events
Rule Owner=SYSMAN
Update Details:
User SYS logged on from kali.谢谢
发布于 2017-03-09 05:34:02
默认情况下,SYSDBA或SYSOPER特权的审计日志存储在AUDIT_FILE_DEST目录中。
SQL> show parameter AUDIT_FILE_DEST
NAME TYPE VALUE
------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/oracle/admin/orcl/adump对于非sys用户,审计日志存储在名为‘and $’的数据字典表中,并有几个视图来获取这些信息。
SELECT view_name
FROM dba_views
WHERE view_name LIKE 'DBA%AUDIT%'
ORDER BY view_name;Kali是用户登录到数据库服务器的主机名/域名。
https://dba.stackexchange.com/questions/166603
复制相似问题