问题描述
嗨,汤姆!
我正在尝试设置一些统一的审核策略,但是无论设置什么,我都不会将操作写入审核跟踪中。
编写的唯一审计是默认安装和启用的审计,所以我可以看到我的所有创建和启用我的策略的命令都被写入审计跟踪,但没有创建的审计。
我使用了来自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;
有了这个选择 (和完全选择),我找不到任何记录,除了
创建/启用策略 (创建审计策略和审计)。没有选择也没有插入,为什么?
我敢肯定,这是我在这里 (一如既往) 缺少的非常基本的东西,但是呢?
问候,
米凯尔
我正在尝试设置一些统一的审核策略,但是无论设置什么,我都不会将操作写入审核跟踪中。
编写的唯一审计是默认安装和启用的审计,所以我可以看到我的所有创建和启用我的策略的命令都被写入审计跟踪,但没有创建的审计。
我使用了来自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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
【纯干货】Oracle 19C RU 19.27 发布,如何快速升级和安装?
Lucifer三思而后行
619次阅读
2025-04-18 14:18:38
Oracle RAC 一键安装翻车?手把手教你如何排错!
Lucifer三思而后行
610次阅读
2025-04-15 17:24:06
XTTS跨版本迁移升级方案(11g to 19c RAC for Linux)
zwtian
506次阅读
2025-04-08 09:12:48
Oracle数据库一键巡检并生成HTML结果,免费脚本速来下载!
陈举超
490次阅读
2025-04-20 10:07:02
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
470次阅读
2025-04-22 00:20:37
Oracle 19c RAC更换IP实战,运维必看!
szrsu
446次阅读
2025-04-08 23:57:08
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
441次阅读
2025-04-22 00:13:51
【活动】分享你的压箱底干货文档,三篇解锁进阶奖励!
墨天轮编辑部
436次阅读
2025-04-17 17:02:24
一页概览:Oracle GoldenGate
甲骨文云技术
433次阅读
2025-04-30 12:17:56
火焰图--分析复杂SQL执行计划的利器
听见风的声音
380次阅读
2025-04-17 09:30:30