暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle 统一审计不会写入跟踪

askTom 2017-04-04
426

问题描述

嗨,汤姆!

我正在尝试设置一些统一的审核策略,但是无论设置什么,我都不会将操作写入审核跟踪中。

编写的唯一审计是默认安装和启用的审计,所以我可以看到我的所有创建和启用我的策略的命令都被写入审计跟踪,但没有创建的审计。

我使用了来自http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/security/sec_uni_audit/sec_uni_audit.html作为我尝试的模板。

This is the setup and what I have done:

-- 验证是否启用了统一审计
select * from v$option where PARAMETER = 'Unified Auditing';

参数值CON_ID
-
统一审计TRUE 0

选择1行。


-开始示例
-- 创建测试表 (data_owner)
create table data_owner.mili_audit_test (col1 varchar2(10));


-创建策略 (sys)
CREATE AUDIT POLICY POL_MILI_TEST
ACTIONS ALL ON DATA_OWNER.MILI_AUDIT_TEST;


-启动策略 (sys)
AUDIT POLICY POL_MILI_TEST EXCEPT DATA_OWNER;


-检查策略是否已创建 (sys)
select POLICY_NAME, AUDIT_OPTION, OBJECT_NAME
from AUDIT_UNIFIED_POLICIES
where POLICY_NAME ='POL_MILI_TEST';


策略名称审计选项对象名称
----------------------------------------
POL_MILI_TEST所有MILI_AUDIT_TEST


-检查策略是否已启用
select POLICY_NAME, ENABLED_OPT, USER_NAME, SUCCESS, FAILURE
from AUDIT_UNIFIED_ENABLED_POLICIES
where POLICY_NAME ='POL_MILI_TEST'´;


POLICY_NAME启用 _opt用户名成功失败
-
POL_MILI_TEST除了数据 _ 所有者是


-运行insterts并从3种不同的架构中进行选择 (sys,data_owner和其他架构)
insert into DATA_OWNER.MILI_AUDIT_TEST values ('Test');

select *
from DATA_OWNER.MILI_AUDIT_TEST;


-> 架构1
------------
创建1行。

COL1
----------
测试1
选择1行。

-> 架构2
------------
创建1行。

COL1
----------
测试2
测试1

选择2行。


-> 架构3
------------
创建1行。

COL1
----------
测试2
测试1
测试3

选择3行。


------------------------------
select *
from UNIFIED_AUDIT_TRAIL
where object_name = 'POL_MILI_TEST'
order by event_timestamp desc;


有了这个选择 (和完全选择),我找不到任何记录,除了
创建/启用策略 (创建审计策略和审计)。没有选择也没有插入,为什么?

我敢肯定,这是我在这里 (一如既往) 缺少的非常基本的东西,但是呢?

问候,
米凯尔

专家解答

你需要做的几件重要的事情:

-启用了统一审核选项 (我认为您已经这样做了)
-审计跟踪 = 无
-刷新审核跟踪以确保您看到所有内容

完成后,我重复了您的脚本并获得了预期的记录

SQL> create table mcdonac.mili_audit_test (col1 varchar2(10));

Table created.

SQL> grant all on mili_audit_test to public;

Grant succeeded.

SQL>
SQL> create audit policy pol_mili_test
  2  actions all on mcdonac.mili_audit_test;

Audit policy created.

SQL>
SQL> audit policy pol_mili_test except mcdonac;

Audit succeeded.

SQL>
SQL> select policy_name, audit_option, object_name
  2  from audit_unified_policies
  3  where policy_name ='POL_MILI_TEST';

POLICY_NAME
--------------------------------------------------------------------------------------------------------------------------------
AUDIT_OPTION
--------------------------------------------------------------------------------------------------------------------------------
OBJECT_NAME
----------------------------------------
POL_MILI_TEST
ALL
MILI_AUDIT_TEST


1 row selected.

SQL> select policy_name, enabled_opt, user_name, success, failure
  2  from audit_unified_enabled_policies
  3  where policy_name ='POL_MILI_TEST';

POLICY_NAME
--------------------------------------------------------------------------------------------------------------------------------
ENABLED
-------
USER_NAME
--------------------------------------------------------------------------------------------------------------------------------
SUC FAI
--- ---
POL_MILI_TEST
EXCEPT
MCDONAC
YES YES


1 row selected.

SQL> conn scott/tiger
Connected.

SQL> insert into mcdonac.mili_audit_test values ('Test');

1 row created.

SQL> commit;

Commit complete.

SQL> select *
  2  from mcdonac.mili_audit_test;

COL1
----------
Test

1 row selected.

SQL> conn mcdonac/******
Connected.

SQL> exec dbms_audit_mgmt.flush_unified_audit_trail;

PL/SQL procedure successfully completed.

SQL> select *
  2  from UNIFIED_AUDIT_TRAIL
  3  where 1=1 --object_name = 'POL_MILI_TEST'
  4  order by event_timestamp desc
  5  @pr
==============================
AUDIT_TYPE                    : Standard
SESSIONID                     : 2146929243
PROXY_SESSIONID               : 0
OS_USERNAME                   : XPS13\hamcdc
USERHOST                      : WORKGROUP\XPS13
TERMINAL                      : XPS13
INSTANCE_ID                   : 1
DBID                          : 872342268
AUTHENTICATION_TYPE           : (TYPE=(DATABASE));
DBUSERNAME                    : MCDONAC
DBPROXY_USERNAME              :
EXTERNAL_USERID               :
GLOBAL_USERID                 :
CLIENT_PROGRAM_NAME           : sqlplus.exe
DBLINK_INFO                   :
XS_USER_NAME                  :
XS_SESSIONID                  :
ENTRY_ID                      : 1
STATEMENT_ID                  : 12
EVENT_TIMESTAMP               : 16-APR-17 02.31.21.348000 PM
ACTION_NAME                   : EXECUTE
RETURN_CODE                   : 0
OS_PROCESS                    : 11740:11176
TRANSACTION_ID                :
SCN                           : 14815791230250
EXECUTION_ID                  :
OBJECT_SCHEMA                 : SYS
OBJECT_NAME                   : DBMS_AUDIT_MGMT
SQL_TEXT                      : BEGIN dbms_audit_mgmt.flush_unified_audit_trail; END;

SQL_BINDS                     :
APPLICATION_CONTEXTS          :
CLIENT_IDENTIFIER             :
NEW_SCHEMA                    :
NEW_NAME                      :
OBJECT_EDITION                :
SYSTEM_PRIVILEGE_USED         :
SYSTEM_PRIVILEGE              :
AUDIT_OPTION                  :
OBJECT_PRIVILEGES             :
ROLE                          :
TARGET_USER                   :
EXCLUDED_USER                 :
EXCLUDED_SCHEMA               :
EXCLUDED_OBJECT               :
CURRENT_USER                  : MCDONAC
ADDITIONAL_INFO               :
UNIFIED_AUDIT_POLICIES        :
FGA_POLICY_NAME               :
XS_INACTIVITY_TIMEOUT         :
XS_ENTITY_TYPE                :
XS_TARGET_PRINCIPAL_NAME      :
XS_PROXY_USER_NAME            :
XS_DATASEC_POLICY_NAME        :
XS_SCHEMA_NAME                :
XS_CALLBACK_EVENT_TYPE        :
XS_PACKAGE_NAME               :
XS_PROCEDURE_NAME             :
XS_ENABLED_ROLE               :
XS_COOKIE                     :
XS_NS_NAME                    :
XS_NS_ATTRIBUTE               :
XS_NS_ATTRIBUTE_OLD_VAL       :
XS_NS_ATTRIBUTE_NEW_VAL       :
DV_ACTION_CODE                :
DV_ACTION_NAME                :
DV_EXTENDED_ACTION_CODE       :
DV_GRANTEE                    :
DV_RETURN_CODE                :
DV_ACTION_OBJECT_NAME         :
DV_RULE_SET_NAME              :
DV_COMMENT                    :
DV_FACTOR_CONTEXT             :
DV_OBJECT_STATUS              :
OLS_POLICY_NAME               :
OLS_GRANTEE                   :
OLS_MAX_READ_LABEL            :
OLS_MAX_WRITE_LABEL           :
OLS_MIN_WRITE_LABEL           :
OLS_PRIVILEGES_GRANTED        :
OLS_PROGRAM_UNIT_NAME         :
OLS_PRIVILEGES_USED           :
OLS_STRING_LABEL              :
OLS_LABEL_COMPONENT_TYPE      :
OLS_LABEL_COMPONENT_NAME      :
OLS_PARENT_GROUP_NAME         :
OLS_OLD_VALUE                 :
OLS_NEW_VALUE                 :
RMAN_SESSION_RECID            :
RMAN_SESSION_STAMP            :
RMAN_OPERATION                :
RMAN_OBJECT_TYPE              :
RMAN_DEVICE_TYPE              :
DP_TEXT_PARAMETERS1           :
DP_BOOLEAN_PARAMETERS1        :
DIRECT_PATH_NUM_COLUMNS_LOADED:
RLS_INFO                      :
KSACL_USER_NAME               :
KSACL_SERVICE_NAME            :
KSACL_SOURCE_LOCATION         :
==============================
AUDIT_TYPE                    : Standard
SESSIONID                     : 653736211
PROXY_SESSIONID               : 0
OS_USERNAME                   : XPS13\hamcdc
USERHOST                      : WORKGROUP\XPS13
TERMINAL                      : XPS13
INSTANCE_ID                   : 1
DBID                          : 872342268
AUTHENTICATION_TYPE           : (TYPE=(DATABASE));
DBUSERNAME                    : SCOTT
DBPROXY_USERNAME              :
EXTERNAL_USERID               :
GLOBAL_USERID                 :
CLIENT_PROGRAM_NAME           : sqlplus.exe
DBLINK_INFO                   :
XS_USER_NAME                  :
XS_SESSIONID                  :
ENTRY_ID                      : 2
STATEMENT_ID                  : 14
EVENT_TIMESTAMP               : 16-APR-17 02.31.21.270000 PM
ACTION_NAME                   : SELECT
RETURN_CODE                   : 0
OS_PROCESS                    : 11740:1180
TRANSACTION_ID                :
SCN                           : 14815791230246
EXECUTION_ID                  :
OBJECT_SCHEMA                 : MCDONAC
OBJECT_NAME                   : MILI_AUDIT_TEST
SQL_TEXT                      : select *
from mcdonac.mili_audit_test
SQL_BINDS                     :
APPLICATION_CONTEXTS          :
CLIENT_IDENTIFIER             :
NEW_SCHEMA                    :
NEW_NAME                      :
OBJECT_EDITION                :
SYSTEM_PRIVILEGE_USED         :
SYSTEM_PRIVILEGE              :
AUDIT_OPTION                  :
OBJECT_PRIVILEGES             :
ROLE                          :
TARGET_USER                   :
EXCLUDED_USER                 :
EXCLUDED_SCHEMA               :
EXCLUDED_OBJECT               :
CURRENT_USER                  : SCOTT
ADDITIONAL_INFO               :
UNIFIED_AUDIT_POLICIES        : POL_MILI_TEST
FGA_POLICY_NAME               :
XS_INACTIVITY_TIMEOUT         :
XS_ENTITY_TYPE                :
XS_TARGET_PRINCIPAL_NAME      :
XS_PROXY_USER_NAME            :
XS_DATASEC_POLICY_NAME        :
XS_SCHEMA_NAME                :
XS_CALLBACK_EVENT_TYPE        :
XS_PACKAGE_NAME               :
XS_PROCEDURE_NAME             :
XS_ENABLED_ROLE               :
XS_COOKIE                     :
XS_NS_NAME                    :
XS_NS_ATTRIBUTE               :
XS_NS_ATTRIBUTE_OLD_VAL       :
XS_NS_ATTRIBUTE_NEW_VAL       :
DV_ACTION_CODE                :
DV_ACTION_NAME                :
DV_EXTENDED_ACTION_CODE       :
DV_GRANTEE                    :
DV_RETURN_CODE                :
DV_ACTION_OBJECT_NAME         :
DV_RULE_SET_NAME              :
DV_COMMENT                    :
DV_FACTOR_CONTEXT             :
DV_OBJECT_STATUS              :
OLS_POLICY_NAME               :
OLS_GRANTEE                   :
OLS_MAX_READ_LABEL            :
OLS_MAX_WRITE_LABEL           :
OLS_MIN_WRITE_LABEL           :
OLS_PRIVILEGES_GRANTED        :
OLS_PROGRAM_UNIT_NAME         :
OLS_PRIVILEGES_USED           :
OLS_STRING_LABEL              :
OLS_LABEL_COMPONENT_TYPE      :
OLS_LABEL_COMPONENT_NAME      :
OLS_PARENT_GROUP_NAME         :
OLS_OLD_VALUE                 :
OLS_NEW_VALUE                 :
RMAN_SESSION_RECID            :
RMAN_SESSION_STAMP            :
RMAN_OPERATION                :
RMAN_OBJECT_TYPE              :
RMAN_DEVICE_TYPE              :
DP_TEXT_PARAMETERS1           :
DP_BOOLEAN_PARAMETERS1        :
DIRECT_PATH_NUM_COLUMNS_LOADED:
RLS_INFO                      :
KSACL_USER_NAME               :
KSACL_SERVICE_NAME            :
KSACL_SOURCE_LOCATION         :
==============================
AUDIT_TYPE                    : Standard
SESSIONID                     : 653736211
PROXY_SESSIONID               : 0
OS_USERNAME                   : XPS13\hamcdc
USERHOST                      : WORKGROUP\XPS13
TERMINAL                      : XPS13
INSTANCE_ID                   : 1
DBID                          : 872342268
AUTHENTICATION_TYPE           : (TYPE=(DATABASE));
DBUSERNAME                    : SCOTT
DBPROXY_USERNAME              :
EXTERNAL_USERID               :
GLOBAL_USERID                 :
CLIENT_PROGRAM_NAME           : sqlplus.exe
DBLINK_INFO                   :
XS_USER_NAME                  :
XS_SESSIONID                  :
ENTRY_ID                      : 1
STATEMENT_ID                  : 12
EVENT_TIMESTAMP               : 16-APR-17 02.31.21.254000 PM
ACTION_NAME                   : INSERT
RETURN_CODE                   : 0
OS_PROCESS                    : 11740:1180
TRANSACTION_ID                : 07000100BD130000
SCN                           : 14815791230240
EXECUTION_ID                  :
OBJECT_SCHEMA                 : MCDONAC
OBJECT_NAME                   : MILI_AUDIT_TEST
SQL_TEXT                      : insert into mcdonac.mili_audit_test values ('Test')
SQL_BINDS                     :
APPLICATION_CONTEXTS          :
CLIENT_IDENTIFIER             :
NEW_SCHEMA                    :
NEW_NAME                      :
OBJECT_EDITION                :
SYSTEM_PRIVILEGE_USED         :
SYSTEM_PRIVILEGE              :
AUDIT_OPTION                  :
OBJECT_PRIVILEGES             :
ROLE                          :
TARGET_USER                   :
EXCLUDED_USER                 :
EXCLUDED_SCHEMA               :
EXCLUDED_OBJECT               :
CURRENT_USER                  : SCOTT
ADDITIONAL_INFO               :
UNIFIED_AUDIT_POLICIES        : POL_MILI_TEST
FGA_POLICY_NAME               :
XS_INACTIVITY_TIMEOUT         :
XS_ENTITY_TYPE                :
XS_TARGET_PRINCIPAL_NAME      :
XS_PROXY_USER_NAME            :
XS_DATASEC_POLICY_NAME        :
XS_SCHEMA_NAME                :
XS_CALLBACK_EVENT_TYPE        :
XS_PACKAGE_NAME               :
XS_PROCEDURE_NAME             :
XS_ENABLED_ROLE               :
XS_COOKIE                     :
XS_NS_NAME                    :
XS_NS_ATTRIBUTE               :
XS_NS_ATTRIBUTE_OLD_VAL       :
XS_NS_ATTRIBUTE_NEW_VAL       :
DV_ACTION_CODE                :
DV_ACTION_NAME                :
DV_EXTENDED_ACTION_CODE       :
DV_GRANTEE                    :
DV_RETURN_CODE                :
DV_ACTION_OBJECT_NAME         :
DV_RULE_SET_NAME              :
DV_COMMENT                    :
DV_FACTOR_CONTEXT             :
DV_OBJECT_STATUS              :
OLS_POLICY_NAME               :
OLS_GRANTEE                   :
OLS_MAX_READ_LABEL            :
OLS_MAX_WRITE_LABEL           :
OLS_MIN_WRITE_LABEL           :
OLS_PRIVILEGES_GRANTED        :
OLS_PROGRAM_UNIT_NAME         :
OLS_PRIVILEGES_USED           :
OLS_STRING_LABEL              :
OLS_LABEL_COMPONENT_TYPE      :
OLS_LABEL_COMPONENT_NAME      :
OLS_PARENT_GROUP_NAME         :
OLS_OLD_VALUE                 :
OLS_NEW_VALUE                 :
RMAN_SESSION_RECID            :
RMAN_SESSION_STAMP            :
RMAN_OPERATION                :
RMAN_OBJECT_TYPE              :
RMAN_DEVICE_TYPE              :
DP_TEXT_PARAMETERS1           :
DP_BOOLEAN_PARAMETERS1        :
DIRECT_PATH_NUM_COLUMNS_LOADED:
RLS_INFO                      :
KSACL_USER_NAME               :
KSACL_SERVICE_NAME            :
KSACL_SOURCE_LOCATION         :
==============================
AUDIT_TYPE                    : Standard
SESSIONID                     : 920231926
PROXY_SESSIONID               : 0
OS_USERNAME                   : XPS13\hamcdc
USERHOST                      : WORKGROUP\XPS13
TERMINAL                      : XPS13
INSTANCE_ID                   : 1
DBID                          : 872342268
AUTHENTICATION_TYPE           : (TYPE=(DATABASE));
DBUSERNAME                    : MCDONAC
DBPROXY_USERNAME              :
EXTERNAL_USERID               :
GLOBAL_USERID                 :
CLIENT_PROGRAM_NAME           : sqlplus.exe
DBLINK_INFO                   :
XS_USER_NAME                  :
XS_SESSIONID                  :
ENTRY_ID                      : 3
STATEMENT_ID                  : 62
EVENT_TIMESTAMP               : 16-APR-17 02.31.21.014000 PM
ACTION_NAME                   : CREATE AUDIT POLICY
RETURN_CODE                   : 0
OS_PROCESS                    : 11740:6136
TRANSACTION_ID                : 0000000000000000
SCN                           : 14815791230223
EXECUTION_ID                  :
OBJECT_SCHEMA                 : SYS
OBJECT_NAME                   : POL_MILI_TEST
SQL_TEXT                      : create audit policy pol_mili_test
actions all on mcdonac.mili_audit_test
SQL_BINDS                     :
APPLICATION_CONTEXTS          :
CLIENT_IDENTIFIER             :
NEW_SCHEMA                    :
NEW_NAME                      :
OBJECT_EDITION                :
SYSTEM_PRIVILEGE_USED         : AUDIT SYSTEM
SYSTEM_PRIVILEGE              :
AUDIT_OPTION                  :
OBJECT_PRIVILEGES             :
ROLE                          :
TARGET_USER                   :
EXCLUDED_USER                 :
EXCLUDED_SCHEMA               :
EXCLUDED_OBJECT               :
CURRENT_USER                  : MCDONAC
ADDITIONAL_INFO               :
UNIFIED_AUDIT_POLICIES        :
FGA_POLICY_NAME               :
XS_INACTIVITY_TIMEOUT         :
XS_ENTITY_TYPE                :
XS_TARGET_PRINCIPAL_NAME      :
XS_PROXY_USER_NAME            :
XS_DATASEC_POLICY_NAME        :
XS_SCHEMA_NAME                :
XS_CALLBACK_EVENT_TYPE        :
XS_PACKAGE_NAME               :
XS_PROCEDURE_NAME             :
XS_ENABLED_ROLE               :
XS_COOKIE                     :
XS_NS_NAME                    :
XS_NS_ATTRIBUTE               :
XS_NS_ATTRIBUTE_OLD_VAL       :
XS_NS_ATTRIBUTE_NEW_VAL       :
DV_ACTION_CODE                :
DV_ACTION_NAME                :
DV_EXTENDED_ACTION_CODE       :
DV_GRANTEE                    :
DV_RETURN_CODE                :
DV_ACTION_OBJECT_NAME         :
DV_RULE_SET_NAME              :
DV_COMMENT                    :
DV_FACTOR_CONTEXT             :
DV_OBJECT_STATUS              :
OLS_POLICY_NAME               :
OLS_GRANTEE                   :
OLS_MAX_READ_LABEL            :
OLS_MAX_WRITE_LABEL           :
OLS_MIN_WRITE_LABEL           :
OLS_PRIVILEGES_GRANTED        :
OLS_PROGRAM_UNIT_NAME         :
OLS_PRIVILEGES_USED           :
OLS_STRING_LABEL              :
OLS_LABEL_COMPONENT_TYPE      :
OLS_LABEL_COMPONENT_NAME      :
OLS_PARENT_GROUP_NAME         :
OLS_OLD_VALUE                 :
OLS_NEW_VALUE                 :
RMAN_SESSION_RECID            :
RMAN_SESSION_STAMP            :
RMAN_OPERATION                :
RMAN_OBJECT_TYPE              :
RMAN_DEVICE_TYPE              :
DP_TEXT_PARAMETERS1           :
DP_BOOLEAN_PARAMETERS1        :
DIRECT_PATH_NUM_COLUMNS_LOADED:
RLS_INFO                      :
KSACL_USER_NAME               :
KSACL_SERVICE_NAME            :
KSACL_SOURCE_LOCATION         :
==============================
AUDIT_TYPE                    : Standard
SESSIONID                     : 920231926
PROXY_SESSIONID               : 0
OS_USERNAME                   : XPS13\hamcdc
USERHOST                      : WORKGROUP\XPS13
TERMINAL                      : XPS13
INSTANCE_ID                   : 1
DBID                          : 872342268
AUTHENTICATION_TYPE           : (TYPE=(DATABASE));
DBUSERNAME                    : MCDONAC
DBPROXY_USERNAME              :
EXTERNAL_USERID               :
GLOBAL_USERID                 :
CLIENT_PROGRAM_NAME           : sqlplus.exe
DBLINK_INFO                   :
XS_USER_NAME                  :
XS_SESSIONID                  :
ENTRY_ID                      : 4
STATEMENT_ID                  : 88
EVENT_TIMESTAMP               : 16-APR-17 02.31.21.014000 PM
ACTION_NAME                   : AUDIT
RETURN_CODE                   : 0
OS_PROCESS                    : 11740:6136
TRANSACTION_ID                : 07000000B6130000
SCN                           : 14815791230231
EXECUTION_ID                  :
OBJECT_SCHEMA                 : SYS
OBJECT_NAME                   : POL_MILI_TEST
SQL_TEXT                      : audit policy pol_mili_test except mcdonac
SQL_BINDS                     :
APPLICATION_CONTEXTS          :
CLIENT_IDENTIFIER             :
NEW_SCHEMA                    :
NEW_NAME                      :
OBJECT_EDITION                :
SYSTEM_PRIVILEGE_USED         : AUDIT SYSTEM
SYSTEM_PRIVILEGE              :
AUDIT_OPTION                  :
OBJECT_PRIVILEGES             :
ROLE                          :
TARGET_USER                   :
EXCLUDED_USER                 : MCDONAC
EXCLUDED_SCHEMA               :
EXCLUDED_OBJECT               :
CURRENT_USER                  : MCDONAC
ADDITIONAL_INFO               :
UNIFIED_AUDIT_POLICIES        :
FGA_POLICY_NAME               :
XS_INACTIVITY_TIMEOUT         :
XS_ENTITY_TYPE                :
XS_TARGET_PRINCIPAL_NAME      :
XS_PROXY_USER_NAME            :
XS_DATASEC_POLICY_NAME        :
XS_SCHEMA_NAME                :
XS_CALLBACK_EVENT_TYPE        :
XS_PACKAGE_NAME               :
XS_PROCEDURE_NAME             :
XS_ENABLED_ROLE               :
XS_COOKIE                     :
XS_NS_NAME                    :
XS_NS_ATTRIBUTE               :
XS_NS_ATTRIBUTE_OLD_VAL       :
XS_NS_ATTRIBUTE_NEW_VAL       :
DV_ACTION_CODE                :
DV_ACTION_NAME                :
DV_EXTENDED_ACTION_CODE       :
DV_GRANTEE                    :
DV_RETURN_CODE                :
DV_ACTION_OBJECT_NAME         :
DV_RULE_SET_NAME              :
DV_COMMENT                    :
DV_FACTOR_CONTEXT             :
DV_OBJECT_STATUS              :
OLS_POLICY_NAME               :
OLS_GRANTEE                   :
OLS_MAX_READ_LABEL            :
OLS_MAX_WRITE_LABEL           :
OLS_MIN_WRITE_LABEL           :
OLS_PRIVILEGES_GRANTED        :
OLS_PROGRAM_UNIT_NAME         :
OLS_PRIVILEGES_USED           :
OLS_STRING_LABEL              :
OLS_LABEL_COMPONENT_TYPE      :
OLS_LABEL_COMPONENT_NAME      :
OLS_PARENT_GROUP_NAME         :
OLS_OLD_VALUE                 :
OLS_NEW_VALUE                 :
RMAN_SESSION_RECID            :
RMAN_SESSION_STAMP            :
RMAN_OPERATION                :
RMAN_OBJECT_TYPE              :
RMAN_DEVICE_TYPE              :
DP_TEXT_PARAMETERS1           :
DP_BOOLEAN_PARAMETERS1        :
DIRECT_PATH_NUM_COLUMNS_LOADED:
RLS_INFO                      :
KSACL_USER_NAME               :
KSACL_SERVICE_NAME            :
KSACL_SOURCE_LOCATION         :
==============================
AUDIT_TYPE                    : Standard
SESSIONID                     : 350031
PROXY_SESSIONID               : 0
OS_USERNAME                   :
USERHOST                      : WORKGROUP\XPS13
TERMINAL                      :
INSTANCE_ID                   : 0
DBID                          : 872342268
AUTHENTICATION_TYPE           :
DBUSERNAME                    : MCDONAC
DBPROXY_USERNAME              :
EXTERNAL_USERID               :
GLOBAL_USERID                 :
CLIENT_PROGRAM_NAME           : sqlplus.exe
DBLINK_INFO                   :
XS_USER_NAME                  :
XS_SESSIONID                  : 000000000000000000000000000000000000000000000000000000000000000000
ENTRY_ID                      : 0
STATEMENT_ID                  : 0
EVENT_TIMESTAMP               : 03-APR-17 12.18.53.274000 PM
ACTION_NAME                   : LOGOFF BY CLEANUP
RETURN_CODE                   : 0
OS_PROCESS                    : 7480:4824
TRANSACTION_ID                : 0000000000000000
SCN                           : 0
EXECUTION_ID                  :
OBJECT_SCHEMA                 :
OBJECT_NAME                   :
SQL_TEXT                      :
SQL_BINDS                     :
APPLICATION_CONTEXTS          :
CLIENT_IDENTIFIER             :
NEW_SCHEMA                    :
NEW_NAME                      :
OBJECT_EDITION                :
SYSTEM_PRIVILEGE_USED         :
SYSTEM_PRIVILEGE              :
AUDIT_OPTION                  :
OBJECT_PRIVILEGES             :
ROLE                          :
TARGET_USER                   :
EXCLUDED_USER                 :
EXCLUDED_SCHEMA               :
EXCLUDED_OBJECT               :
CURRENT_USER                  :
ADDITIONAL_INFO               :
UNIFIED_AUDIT_POLICIES        :
FGA_POLICY_NAME               :
XS_INACTIVITY_TIMEOUT         : 0
XS_ENTITY_TYPE                :
XS_TARGET_PRINCIPAL_NAME      :
XS_PROXY_USER_NAME            :
XS_DATASEC_POLICY_NAME        :
XS_SCHEMA_NAME                :
XS_CALLBACK_EVENT_TYPE        :
XS_PACKAGE_NAME               :
XS_PROCEDURE_NAME             :
XS_ENABLED_ROLE               :
XS_COOKIE                     :
XS_NS_NAME                    :
XS_NS_ATTRIBUTE               :
XS_NS_ATTRIBUTE_OLD_VAL       :
XS_NS_ATTRIBUTE_NEW_VAL       :
DV_ACTION_CODE                : 0
DV_ACTION_NAME                :
DV_EXTENDED_ACTION_CODE       : 0
DV_GRANTEE                    :
DV_RETURN_CODE                : 0
DV_ACTION_OBJECT_NAME         :
DV_RULE_SET_NAME              :
DV_COMMENT                    :
DV_FACTOR_CONTEXT             :
DV_OBJECT_STATUS              :
OLS_POLICY_NAME               :
OLS_GRANTEE                   :
OLS_MAX_READ_LABEL            :
OLS_MAX_WRITE_LABEL           :
OLS_MIN_WRITE_LABEL           :
OLS_PRIVILEGES_GRANTED        :
OLS_PROGRAM_UNIT_NAME         :
OLS_PRIVILEGES_USED           :
OLS_STRING_LABEL              :
OLS_LABEL_COMPONENT_TYPE      :
OLS_LABEL_COMPONENT_NAME      :
OLS_PARENT_GROUP_NAME         :
OLS_OLD_VALUE                 :
OLS_NEW_VALUE                 :
RMAN_SESSION_RECID            : 0
RMAN_SESSION_STAMP            : 0
RMAN_OPERATION                :
RMAN_OBJECT_TYPE              :
RMAN_DEVICE_TYPE              :
DP_TEXT_PARAMETERS1           :
DP_BOOLEAN_PARAMETERS1        :
DIRECT_PATH_NUM_COLUMNS_LOADED: 0
RLS_INFO                      :
KSACL_USER_NAME               :
KSACL_SERVICE_NAME            :
KSACL_SOURCE_LOCATION         :

PL/SQL procedure successfully completed.


SQL>
复制


「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论