Oracle 8i 起棄用 INTERNAL,改用 SYSDBA/SYSOPER 角色控制啟動/關閉等特權操作。為防濫用,需審計所有特權登入。
SYSDBA 連線,Oracle 自動在 $ORACLE_HOME/rdbms/audit/ora_.aud 建立審計檔,**無需啟動資料庫審計參數**。SQL> CONN SYS@GS1 AS SYSDBA
Password: ********
Connected.
$ cat $ORACLE_HOME/rdbms/audit/ora_589980.aud
Audit file /ora1/oracle/app/product/8.1.6/rdbms/audit/ora_589980.aud
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
...
Fri Sep 21 10:26:57 2001
ACTION : 'CONNECT INTERNAL'
OSPRIV : DBA
CLIENT USER: Administrator
CLIENT TERMINAL: XIAOFEISHI
#!/bin/ksh
AUDIT_DIR=$ORACLE_HOME/rdbms/audit
DAYS=1
find $AUDIT_DIR -name "ora_*.aud" -mtime -$DAYS -exec grep -l "CONNECT INTERNAL" {} \; |
while read file; do
echo "=== $file ==="
grep -E "ACTION|CLIENT USER|CLIENT TERMINAL|Fri|Mon|Tue|Wed|Thu|Sat|Sun" $file
done
輸出每日特權登入清單,納入安稽報表。
SVRMGRL,完全依賴 SQLPLUS ... AS SYSDBA。AUDIT_SYS_OPERATIONS=TRUE) 將 SYS 操作寫入 SYS.AUD$ 或 OS XML 審計檔,查詢更便利:SELECT * FROM DBA_AUDIT_SESSION WHERE USERNAME='SYS';AUDIT_TRAIL=XML,EXTENDED 並整合至 SIEM。