Oracle 11g数据库审计功能应用实例解析

复制SQL> selectos_username,数审计实例userhost,terminal,username,count(*)   2    from dba_audit_trail   3   where returncode = 1017 4   group byos_username,userhost,username,terminal;   OS_USERNAME                    USERHOST                       TERMINAL     USERNAME       COUNT(*)   ------------------------------------------------------------ ------------ ------------ ----------   DavidDai\Administrator         WORKGROUP\DAVIDDAI             DAVIDDAI    ICD                   7   DavidDai\Administrator         WORKGROUP\DAVIDDAI             DAVIDDAI     SYSTEM                9   DavidDai\Administrator         WORKGROUP\DAVIDDAI             DAVIDDAI     SYS                   3   DavidDai\Administrator         WORKGROUP\DAVIDDAI             DAVIDDAI     EXIT                  1  1.2.3.4.5.6.7.8.9.10.