-
编辑 删除
oracle_database_vault 配置
通过DBCA 配置数据库组件VAULT,再通过以下步骤实现数据管控功能1.创建realmexec dvsys.dbms_macadm.create_realm('TOPUP_REALM','Limit unauthorized users access to data','Y', 0);exec dvsys.dbms_macadm.add_obj...
-
编辑 删除
oracle_wrap 加解密示例.txt
$wrap iname=sp_businessgather_cardpaystat.sql PL/SQL Wrapper: Release 11.2.0.2.0- 64bit Production on Wed Aug 22 15:49:25 2012Copyright (c) 1993, 2009, Oracle. All rights reserved.Processing ...
-
编辑 删除
由业务需求引起的left join & right join
CREATE OR REPLACE FORCE VIEW TOPUP.VIEW_FINANCE_SALESTAT_AGENT( ID, STATDATE, AGENTID, PARMONEY, ACTUALMONEY, INMONEY, &nbs...
-
编辑 删除
审核数据库DDL操作记录实现
1. 操作记录表CREATE TABLE TOPUP.TAB_AUDIT_DDL_RECORD( TIME DATE, SESSION_ID NUMBER, OS_USER ...
-
编辑 删除
oracle 11g wallet configure
cat $ORACLE_HOME/network/admin/sqlnet.oraENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY=/u01/product/oracle/11.2.0/db_1/network/admin/wallet) )SQL...
