PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.0 HotFix 1
- All Products
exec rdsadmin.rdsadmin_master_util.create_archivelog_dir; exec rdsadmin.rdsadmin_master_util.create_onlinelog_dir;
GRANT READ ON DIRECTORY ONLINELOG_DIR to "ORACAPTL1"; GRANT READ ON DIRECTORY ARCHIVELOG_DIR to "ORACAPTL1";
begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'DBA_USERS', p_grantee => 'ORACAPTL1', p_privilege => 'SELECT', p_grant_option => 'false'); end; -- begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'V_$PARAMETER', p_grantee => 'ORACAPTL1', p_privilege => 'SELECT'); end; -- begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'V_$SPPARAMETER', p_grantee => 'ORACAPTL1', p_privilege => 'SELECT'); end; -- begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'V_$STANDBY_LOG', p_grantee => 'ORACAPTL1', p_privilege => 'SELECT'); end; -- begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'V_$VERSION', p_grantee => 'ORACAPTL1', p_privilege => 'SELECT'); end; -- begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'INDPART$', p_grantee => 'ORACAPTL1', p_privilege => 'SELECT'); end; -- To register sources and perform other tasks in the PowerExchange Navigator: begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'V_$PARAMETER', p_grantee => 'registration_user', p_privilege => 'SELECT'); end;