时间：2021-07-01 10:21:17 帮助过：20人阅读
DYNAMICPORTLIST 7856-7866
AUTOSTART EXTRACT *
AUTORESTART EXTRACT *
PURGEOLDEXTRACTS ./dirdat/*, usecheckpoints, minkeepdays 3
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
启动goldengate守护进程
GGSCI > start mgr
查看进程状态，如下即为启动：
GGSCI > info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
10：在源端设置要复制的表
设置表级附加日志：
SQL> set pagesize 9999
select ‘alter table ‘|| owner||‘.‘||table_name||‘ logging;‘from dba_tables where owner in (‘CONGOU‘,‘DBLINKUSR‘,‘DBUSRMKT‘,‘DBUSRPOP‘,‘DBUSRPUB‘,‘DBUSRSET‘,‘DBUSRSYS‘,‘DBUSRXMLT‘,‘PORTAL‘) and logging=‘NO‘;
‘ALTERTABLE‘||OWNER||‘.‘||TABLE_NAME||‘LOGGING;‘
--------------------------------------------------------------------------------
alter table DBUSRPUB.TKTCARDMZREC logging;
alter table DBUSRPUB.TEM_GOODSPRICE_REP logging;
alter table DBUSRPUB.TEMP_CALCTKPARK logging;
alter table DBUSRPUB.GOODSPRICE_TMP logging;
alter table DBUSRPUB.GOODSMFPRICE_TMP logging;
alter table DBUSRPUB.ADJUSTCOST_LIST logging;
alter table DBUSRMKT.TKTSELLYQCALC logging;
alter table DBUSRMKT.TKTGROUPYQCALC logging;
alter table DBUSRMKT.TKTFQTEMPLIST logging;
alter table DBUSRMKT.TKTCALCMAXFQZJB logging;
alter table DBUSRMKT.SUPPCLOSE_T_8 logging;
alter table DBUSRMKT.SUPPCLOSE_T_7 logging;
alter table DBUSRMKT.SUPPCLOSE_T_6 logging;
alter table DBUSRMKT.SUPPCLOSE_T_5 logging;
alter table DBUSRMKT.SUPPCLOSE_T_4 logging;
alter table DBUSRMKT.SUPPCLOSE_T_3 logging;
alter table DBUSRMKT.SUPPCLOSE_T_2 logging;
alter table DBUSRMKT.SUPPCLOSE_T_1 logging;
alter table DBUSRMKT.STOCKTRACK logging;
alter table DBUSRMKT.SELLLISTTEMP logging;
alter table DBUSRMKT.REPMFCATTEMP logging;
alter table DBUSRMKT.REPLENISHTEMP logging;
alter table DBUSRMKT.PAYMENTTEMP logging;
alter table DBUSRMKT.BINSTRHEAD_TEMP logging;
alter table DBUSRSET.SUPPAYEDDETAIL_TEMP logging;
alter table DBUSRSET.SUPPAYDETAIL_TEMP logging;
alter table DBUSRPOP.TKTCARDMZREC logging;
alter table DBUSRPOP.TEMP_CALCTKPARK logging;
alter table CONGOU.USERPOST logging;
alter table CONGOU.USERACCOUNT logging;
alter table CONGOU.TEMPLATEORGUSE logging;
alter table CONGOU.TEMPLATEORGSETRES logging;
alter table CONGOU.TEMPLATEORGSET logging;
alter table CONGOU.TEMPLATEORG logging;
alter table CONGOU.ROLESRES logging;
alter table CONGOU.ROLES logging;
alter table CONGOU.POSTSRES logging;
alter table CONGOU.POSTS logging;
alter table CONGOU.ORGANIZATIONBIND logging;
alter table CONGOU.ORGANIZATION logging;
alter table CONGOU.MODULERES logging;
alter table CONGOU.MODULEMETHODS logging;
alter table CONGOU.MODULE logging;
alter table CONGOU.MAINPAGERES logging;
alter table CONGOU.MAINPAGE logging;
alter table CONGOU.ENTERPRISE logging;
alter table CONGOU.DEPARTMENTRES logging;
alter table CONGOU.DEPARTMENT logging;
alter table CONGOU.DBNODERES logging;
alter table CONGOU.DBNODE logging;
50 rows selected.
执行上述alter table语句。
设置分区表附加日志：
SQL> select ‘alter table ‘|| table_owner||‘.‘||table_name||‘ logging;‘from dba_tab_partitions where table_owner in (‘CONGOU‘,‘DBLINKUSR‘,‘DBUSRMKT‘,‘DBUSRPOP‘,‘DBUSRPUB‘,‘DBUSRSET‘,‘DBUSRSYS‘,‘DBUSRXMLT‘,‘PORTAL‘) and logging=‘NO‘;
no rows selected
查看表列类型是否在goldengate支持之内：
官方文档名字：
GoldenGate Oracle Installation and Setup Guide Release 11.2.1
所在章节：
1.5.9 Non-supported Oracle data types
如下列出的就是不支持的类型
Oracle GoldenGate does not support the following data types.
■ Abstract data types (ADT) with scalar, LOBs, VARRAYS, nested tables, and/or REFsANYDATA
■ ANYDATASET
■ ANYTYPE
■ BFILE
■ MLSLABEL
■ ORDDICOM
■ TIMEZONE_ABBR
■ URITYPE
■ UROWID
查看数据库数据字典，数据库中的数据类型：
SQL> select DATA_TYPE from dba_tab_columns where OWNER in (‘CONGOU‘,‘DBLINKUSR‘,‘DBUSRMKT‘,‘DBUSRPOP‘,‘DBUSRPUB‘,‘DBUSRSET‘,‘DBUSRSYS‘,‘DBUSRXMLT‘,‘PORTAL‘) group by DATA_TYPE;
DATA_TYPE
--------------------------------------------------------------------------------
LONG RAW
LONG
FLOAT
TIMESTAMP(6)
NVARCHAR2
NUMBER
CHAR
CLOB
DATE
UNDEFINED
VARCHAR2
BLOB
12 rows selected.
查看复制的表中是否有压缩表：因为goldengate不支持压缩表
SQL> select COMPRESSION from dba_tables where owner in (‘CONGOU‘,‘DBLINKUSR‘,‘DBUSRMKT‘,‘DBUSRPOP‘,‘DBUSRPUB‘,‘DBUSRSET‘,‘DBUSRSYS‘,‘DBUSRXMLT‘,‘PORTAL‘) group by COMPRESSION;
COMPRESS
--------
DISABLED
查看复制的分区表中是否有压缩表：
SQL> select ‘alter table ‘||table_owner||‘.‘||table_name||‘ move partition ‘||partition_name||‘nocompress update indexes;‘from dba_tab_partitions where table_owner in(‘CONGOU‘,‘DBLINKUSR‘,‘DBUSRMKT‘,‘DBUSRPOP‘,‘DBUSRPUB‘,‘DBUSRSET‘,‘DBUSRSYS‘,‘DBUSRXMLT‘,‘PORTAL‘)and compression=‘ENABLED‘;
no rows selected
11：源端设置表级附加日志
SQL> spool add_trandata.txt
set pagesize 9999
select ‘add trandata ‘||owner||‘.‘||table_name from dba_tables where owner in (‘CONGOU‘,‘DBLINKUSR‘,‘DBUSRMKT‘,‘DBUSRPOP‘,‘DBUSRPUB‘,‘DBUSRSET‘,‘DBUSRSYS‘,‘DBUSRXMLT‘,‘PORTAL‘);
SQL> spool off;
由于上述语句查到的输出语句较多，这里就不一一列出。把输出的语句，登陆ggsci后执行之。
GGSCI > dblogin userid goldengate, password goldengate;
Successfully logged into database.
执行那些一堆命令。
GGSCI > add trandata DBUSRSYS.*
add trandata DBUSRPUB.*
add trandata CONGOU.*
add trandata DBUSRPOP.*
add trandata DBUSRSET.*
add trandata PORTAL.*
add trandata DBUSRXMLT.*
add trandata DBUSRMKT.*
add trandata DBLINKUSR.*
12: 源端创建capture进程
GGSCI (hncdfdb1) 1> add extract ext_hq, tranlog, begin now, threads 1;
GGSCI (hncdfdb1) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT_HQ00:00:00 00:00:32
GGSCI (hncdfdb1) 3> add exttrail ./dirdat/r1, extract ext_hq, MEGABYTES 200
查看数据库的字符集：
SQL> set pagesize 9999
col name for a35
col value for a30
select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET ZHS16GBK
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.5.0
注意以上查询的红色字体部分，要和以下红色部分一样：
GGSCI (hncdfdb1) 1> edit params ext_hq
EXTRACT ext_hq
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_SID=hncdfhq)
userid goldengate, password goldengate
REPORTCOUNT EVERY 1 MINUTES, RATE
numfiles 5000
DISCARDFILE ./dirrpt/ext_hq.dsc, APPEND, MEGABYTES 1000
DISCARDROLLOVER AT 3:00
exttrail ./dirdat/r1, megabytes 200
dynamicresolution
TRANLOGOPTIONS EXCLUDEUSER goldengate
TRANLOGOPTIONS convertucs2clobs
TABLE DBUSRSYS.*;
TABLE CONGOU.*;
TABLE DBUSRPOP.*;
TABLE PORTAL.*;
TABLE DBUSRXMLT.*;
TABLE DBUSRMKT.*;
TABLE DBLINKUSR.*;
TABLE DBUSRSET.*;
TABLE DBUSRPUB.*;
启动capture 进程
GGSCI (hncdfdb1) 1> start ext_hq
Sending START request to MANAGER ...
EXTRACT EXT_HQ starting
GGSCI (hncdfdb1) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_HQ00:00:02 00:00:03
13：源端创建datapump进程
GGSCI (zaibei) 8> add extract dpe_hq, exttrailsource ./dirdat/r1
GGSCI (zaibei) 9> add rmttrail ./dirdat/d1, EXTRACT dpe_hq, MEGABYTES 200
GGSCI (zaibei) 10> edit params dpe_hq
extract dpe_hq
dynamicresolution
passthru
rmthost 10.191.1.10, mgrport 7855, compress
rmttrail ./dirdat/d1
numfiles 5000
TABLE DBUSRSYS.*;
TABLE CONGOU.*;
TABLE DBUSRPOP.*;
TABLE PORTAL.*;
TABLE DBUSRXMLT.*;
TABLE DBUSRMKT.*;
TABLE DBLINKUSR.*;
TABLE DBUSRSET.*;
TABLE DBUSRPUB.*;
启动datapump进程：
GGSCI (zaibei) 11> start dpe_hq
Sending START request to MANAGER ...
EXTRACT DPE_HQ starting
GGSCI (zaibei) 12> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPE_HQ00:00:00 00:02:50
14：验证源端capture和datapump进程
源端
$ pwd
/oradata2/goldengate
$ ls -l dirdat
总用量40
-rw-rw-rw-. 1 oracle oinstall 38886 6月 20 12:22 r1000000
目标端
[oracle@test-gg goldengate]$ pwd
/oradb/goldengate
[oracle@test-gg goldengate]$ ls -l dirdat
total 40
-rw-rw-rw-. 1 oracle oinstall 39117 Jun 20 12:20 d1000000
15：目标端创建表空间、创建用户、赋用户权限
源端查询表空间情况
SQL> set pagesize 9999
col file_name for a60
col tablespace_name for a10
select namefrom v$tablespace;
NAME
------------------------------
SYSTEM
RBSG_SPC
SYSAUX
TEMP_SPC
DATA_SPC
INDX_SPC
USERS
GOLDENGATE
8 rows selected
在目标数据库创建和源数据库同名并空间致少相同的表空间
SQL> create tablespace RBSG_SPC datafile ‘/goldengate/oradata/hncdfhq/rbsg_spc.dbf‘ size 4G autoextend on;
create tablespace DATA_SPC datafile ‘/goldengate/oradata/hncdfhq/data_spc.dbf‘ size 4G autoextend on;
create tablespace INDX_SPC datafile ‘/goldengate/oradata/hncdfhq/indx_spc.dbf‘ size 4G autoextend on;
create tablespace GOLDENGATE datafile ‘/goldengate/oradata/hncdfhq/goldengate01.dbf ‘ size 4G autoextend on;
在源端查询用户默认的表空间
SQL> col username for a15
col default_tablespace for a15
col TEMPORARY_TABLESPACE for a15
select username,default_tablespace,TEMPORARY_TABLESPACE from dba_users where username in (‘CONGOU‘,‘DBLINKUSR‘,‘DBUSRMKT‘,‘DBUSRPOP‘,‘DBUSRPUB‘,‘DBUSRSET‘,‘DBUSRSYS‘,‘DBUSRXMLT‘,‘PORTAL‘);
USERNAME DEFAULT_TABLESP TEMPORARY_TABLE
--------------- --------------- ---------------
DBUSRPUB DATA_SPC TEMP_SPC
DBUSRMKT DATA_SPC TEMP_SPC
DBUSRPOP USERS TEMP_SPC
DBUSRXMLT DATA_SPC TEMP_SPC
DBUSRSET DATA_SPC TEMP_SPC
DBUSRSYS DATA_SPC TEMP_SPC
CONGOU DATA_SPC TEMP_SPC
PORTAL USERS TEMP_SPC
DBLINKUSR DATA_SPC TEMP_SPC
9 rows selected.
目标端创建临时表空间
SQL> create temporary tablespace TEMP_SPC tempfile ‘/goldengate/oradata/hncdfhq/temp_spc.dbf‘ size 4G autoextend on;
在目标端创建用户
SQL> create user DBUSRSYS identified by future default tablespace DATA_SPC temporary tablespace TEMP_SPC;
create user DBUSRPUB identified by future default tablespace DATA_SPC temporary tablespace TEMP_SPC;
create user CONGOU identified by future default tablespace DATA_SPC temporary tablespace TEMP_SPC;
create user DBUSRPOP identified by future default tablespace USERS temporary tablespace TEMP_SPC;
create user DBUSRSET identified by future default tablespace DATA_SPC temporary tablespace TEMP_SPC;
create user PORTALidentified by future default tablespace USERS temporary tablespace TEMP_SPC;
create user DBUSRXMLT identified by future default tablespace DATA_SPC temporary tablespace TEMP_SPC;
create user DBUSRMKT identified by future default tablespace DATA_SPC temporary tablespace TEMP_SPC;
create user DBLINKUSR identified by future default tablespace DATA_SPC temporary tablespace TEMP_SPC;
在源端查询，然后在目标端赋予用户权限
SQL> set pagesize 9999
select ‘grant ‘|| privilege ||‘ to CONGOU;‘ from dba_sys_privs where grantee=‘CONGOU‘
union
select ‘grant ‘|| privilege ||‘ to CONGOU;‘ from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee=‘CONGOU‘ )
union
select ‘grant ‘|| privilege ||‘ to CONGOU;‘ from dba_tab_privs where grantee=‘CONGOU‘;
grant ADMINISTER ANY SQL TUNING SET to CONGOU;
grant ADMINISTER DATABASE TRIGGER to CONGOU;
grant ADMINISTER RESOURCE MANAGER to CONGOU;
grant ADMINISTER SQL TUNING SET to CONGOU;
grant ADVISOR to CONGOU;
grant ALTER ANY CLUSTER to CONGOU;
grant ALTER ANY DIMENSION to CONGOU;
grant ALTER ANY EVALUATION CONTEXT to CONGOU;
grant ALTER ANY INDEX to CONGOU;
grant ALTER ANY INDEXTYPE to CONGOU;
grant ALTER ANY LIBRARY to CONGOU;
grant ALTER ANY MATERIALIZED VIEW to CONGOU;
grant ALTER ANY OUTLINE to CONGOU;
grant ALTER ANY PROCEDURE to CONGOU;
grant ALTER ANY ROLE to CONGOU;
grant ALTER ANY RULE SET to CONGOU;
grant ALTER ANY RULE to CONGOU;
grant ALTER ANY SEQUENCE to CONGOU;
grant ALTER ANY SQL PROFILE to CONGOU;
grant ALTER ANY TABLE to CONGOU;
grant ALTER ANY TRIGGER to CONGOU;
grant ALTER ANY TYPE to CONGOU;
grant ALTER DATABASE to CONGOU;
grant ALTER PROFILE to CONGOU;
grant ALTER RESOURCE COST to CONGOU;
grant ALTER ROLLBACK SEGMENT to CONGOU;
grant ALTER SESSION to CONGOU;
grant ALTER SYSTEM to CONGOU;
grant ALTER TABLESPACE to CONGOU;
grant ALTER USER to CONGOU;
grant ANALYZE ANY DICTIONARY to CONGOU;
grant ANALYZE ANY to CONGOU;
grant AUDIT ANY to CONGOU;
grant AUDIT SYSTEM to CONGOU;
grant BACKUP ANY TABLE to CONGOU;
grant BECOME USER to CONGOU;
grant CHANGE NOTIFICATION to CONGOU;
grant COMMENT ANY TABLE to CONGOU;
grant CREATE ANY CLUSTER to CONGOU;
grant CREATE ANY CONTEXT to CONGOU;
grant CREATE ANY DIMENSION to CONGOU;
grant CREATE ANY DIRECTORY to CONGOU;
grant CREATE ANY EVALUATION CONTEXT to CONGOU;
grant CREATE ANY INDEX to CONGOU;
grant CREATE ANY INDEXTYPE to CONGOU;
grant CREATE ANY JOB to CONGOU;
grant CREATE ANY LIBRARY to CONGOU;
grant CREATE ANY MATERIALIZED VIEW to CONGOU;
grant CREATE ANY OPERATOR to CONGOU;
grant CREATE ANY OUTLINE to CONGOU;
grant CREATE ANY PROCEDURE to CONGOU;
grant CREATE ANY RULE SET to CONGOU;
grant CREATE ANY RULE to CONGOU;
grant CREATE ANY SEQUENCE to CONGOU;
grant CREATE ANY SQL PROFILE to CONGOU;
grant CREATE ANY SYNONYM to CONGOU;
grant CREATE ANY TABLE to CONGOU;
grant CREATE ANY TRIGGER to CONGOU;
grant CREATE ANY TYPE to CONGOU;
grant CREATE ANY VIEW to CONGOU;
grant CREATE CLUSTER to CONGOU;
grant CREATE DATABASE LINK to CONGOU;
grant CREATE DIMENSION to CONGOU;
grant CREATE EVALUATION CONTEXT to CONGOU;
grant CREATE EXTERNAL JOB to CONGOU;
grant CREATE INDEXTYPE to CONGOU;
grant CREATE JOB to CONGOU;
grant CREATE LIBRARY to CONGOU;
grant CREATE MATERIALIZED VIEW to CONGOU;
grant CREATE OPERATOR to CONGOU;
grant CREATE PROCEDURE to CONGOU;
grant CREATE PROFILE to CONGOU;
grant CREATE PUBLIC DATABASE LINK to CONGOU;
grant CREATE PUBLIC SYNONYM to CONGOU;
grant CREATE ROLE to CONGOU;
grant CREATE ROLLBACK SEGMENT to CONGOU;
grant CREATE RULE SET to CONGOU;
grant CREATE RULE to CONGOU;
grant CREATE SEQUENCE to CONGOU;
grant CREATE SESSION to CONGOU;
grant CREATE SYNONYM to CONGOU;
grant CREATE TABLE to CONGOU;
grant CREATE TABLESPACE to CONGOU;
grant CREATE TRIGGER to CONGOU;
grant CREATE TYPE to CONGOU;
grant CREATE USER to CONGOU;
grant CREATE VIEW to CONGOU;
grant DEBUG ANY PROCEDURE to CONGOU;
grant DEBUG CONNECT SESSION to CONGOU;
grant DELETE ANY TABLE to CONGOU;
grant DEQUEUE ANY QUEUE to CONGOU;
grant DROP ANY CLUSTER to CONGOU;
grant DROP ANY CONTEXT to CONGOU;
grant DROP ANY DIMENSION to CONGOU;
grant DROP ANY DIRECTORY to CONGOU;
grant DROP ANY EVALUATION CONTEXT to CONGOU;
grant DROP ANY INDEX to CONGOU;
grant DROP ANY INDEXTYPE to CONGOU;
grant DROP ANY LIBRARY to CONGOU;
grant DROP ANY MATERIALIZED VIEW to CONGOU;
grant DROP ANY OPERATOR to CONGOU;
grant DROP ANY OUTLINE to CONGOU;
grant DROP ANY PROCEDURE to CONGOU;
grant DROP ANY ROLE to CONGOU;
grant DROP ANY RULE SET to CONGOU;
grant DROP ANY RULE to CONGOU;
grant DROP ANY SEQUENCE to CONGOU;
grant DROP ANY SQL PROFILE to CONGOU;
grant DROP ANY SYNONYM to CONGOU;
grant DROP ANY TABLE to CONGOU;
grant DROP ANY TRIGGER to CONGOU;
grant DROP ANY TYPE to CONGOU;
grant DROP ANY VIEW to CONGOU;
grant DROP PROFILE to CONGOU;
grant DROP PUBLIC DATABASE LINK to CONGOU;
grant DROP PUBLIC SYNONYM to CONGOU;
grant DROP ROLLBACK SEGMENT to CONGOU;
grant DROP TABLESPACE to CONGOU;
grant DROP USER to CONGOU;
grant ENQUEUE ANY QUEUE to CONGOU;
grant EXECUTE ANY CLASS to CONGOU;
grant EXECUTE ANY EVALUATION CONTEXT to CONGOU;
grant EXECUTE ANY INDEXTYPE to CONGOU;
grant EXECUTE ANY LIBRARY to CONGOU;
grant EXECUTE ANY OPERATOR to CONGOU;
grant EXECUTE ANY PROCEDURE to CONGOU;
grant EXECUTE ANY PROGRAM to CONGOU;
grant EXECUTE ANY RULE SET to CONGOU;
grant EXECUTE ANY RULE to CONGOU;
grant EXECUTE ANY TYPE to CONGOU;
grant EXPORT FULL DATABASE to CONGOU;
grant FLASHBACK ANY TABLE to CONGOU;
grant FORCE ANY TRANSACTION to CONGOU;
grant FORCE TRANSACTION to CONGOU;
grant GLOBAL QUERY REWRITE to CONGOU;
grant GRANT ANY OBJECT PRIVILEGE to CONGOU;
grant GRANT ANY PRIVILEGE to CONGOU;
grant GRANT ANY ROLE to CONGOU;
grant IMPORT FULL DATABASE to CONGOU;
grant INSERT ANY TABLE to CONGOU;
grant LOCK ANY TABLE to CONGOU;
grant MANAGE ANY FILE GROUP to CONGOU;
grant MANAGE ANY QUEUE to CONGOU;
grant MANAGE FILE GROUP to CONGOU;
grant MANAGE SCHEDULER to CONGOU;
grant MANAGE TABLESPACE to CONGOU;
grant MERGE ANY VIEW to CONGOU;
grant ON COMMIT REFRESH to CONGOU;
grant QUERY REWRITE to CONGOU;
grant READ ANY FILE GROUP to CONGOU;
grant RESTRICTED SESSION to CONGOU;
grant RESUMABLE to CONGOU;
grant SELECT ANY DICTIONARY to CONGOU;
grant SELECT ANY SEQUENCE to CONGOU;
grant SELECT ANY TABLE to CONGOU;
grant SELECT ANY TRANSACTION to CONGOU;
grant UNDER ANY TABLE to CONGOU;
grant UNDER ANY TYPE to CONGOU;
grant UNDER ANY VIEW to CONGOU;
grant UNLIMITED TABLESPACE to CONGOU;
grant UPDATE ANY TABLE to CONGOU;
SQL> select ‘grant ‘|| privilege ||‘ to DBLINKUSR;‘ from dba_sys_privs where grantee=‘DBLINKUSR‘
union
select ‘grant ‘|| privilege ||‘ to DBLINKUSR;‘ from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee=‘DBLINKUSR‘ )
union
select ‘grant ‘|| privilege ||‘ to DBLINKUSR;‘ from dba_tab_privs where grantee=‘DBLINKUSR‘;
grant ADMINISTER ANY SQL TUNING SET to DBLINKUSR;
grant ADMINISTER DATABASE TRIGGER to DBLINKUSR;
grant ADMINISTER RESOURCE MANAGER to DBLINKUSR;
grant ADMINISTER SQL TUNING SET to DBLINKUSR;
grant ADVISOR to DBLINKUSR;
grant ALTER ANY CLUSTER to DBLINKUSR;
grant ALTER ANY DIMENSION to DBLINKUSR;
grant ALTER ANY EVALUATION CONTEXT to DBLINKUSR;
grant ALTER ANY INDEX to DBLINKUSR;
grant ALTER ANY INDEXTYPE to DBLINKUSR;
grant ALTER ANY LIBRARY to DBLINKUSR;
grant ALTER ANY MATERIALIZED VIEW to DBLINKUSR;
grant ALTER ANY OUTLINE to DBLINKUSR;
grant ALTER ANY PROCEDURE to DBLINKUSR;
grant ALTER ANY ROLE to DBLINKUSR;
grant ALTER ANY RULE SET to DBLINKUSR;
grant ALTER ANY RULE to DBLINKUSR;
grant ALTER ANY SEQUENCE to DBLINKUSR;
grant ALTER ANY SQL PROFILE to DBLINKUSR;
grant ALTER ANY TABLE to DBLINKUSR;
grant ALTER ANY TRIGGER to DBLINKUSR;
grant ALTER ANY TYPE to DBLINKUSR;
grant ALTER DATABASE to DBLINKUSR;
grant ALTER PROFILE to DBLINKUSR;
grant ALTER RESOURCE COST to DBLINKUSR;
grant ALTER ROLLBACK SEGMENT to DBLINKUSR;
grant ALTER SESSION to DBLINKUSR;
grant ALTER SYSTEM to DBLINKUSR;
grant ALTER TABLESPACE to DBLINKUSR;
grant ALTER USER to DBLINKUSR;
grant ANALYZE ANY DICTIONARY to DBLINKUSR;
grant ANALYZE ANY to DBLINKUSR;
grant AUDIT ANY to DBLINKUSR;
grant AUDIT SYSTEM to DBLINKUSR;
grant BACKUP ANY TABLE to DBLINKUSR;
grant BECOME USER to DBLINKUSR;
grant CHANGE NOTIFICATION to DBLINKUSR;
grant COMMENT ANY TABLE to DBLINKUSR;
grant CREATE ANY CLUSTER to DBLINKUSR;
grant CREATE ANY CONTEXT to DBLINKUSR;
grant CREATE ANY DIMENSION to DBLINKUSR;
grant CREATE ANY DIRECTORY to DBLINKUSR;
grant CREATE ANY EVALUATION CONTEXT to DBLINKUSR;
grant CREATE ANY INDEX to DBLINKUSR;
grant CREATE ANY INDEXTYPE to DBLINKUSR;
grant CREATE ANY JOB to DBLINKUSR;
grant CREATE ANY LIBRARY to DBLINKUSR;
grant CREATE ANY MATERIALIZED VIEW to DBLINKUSR;
grant CREATE ANY OPERATOR to DBLINKUSR;
grant CREATE ANY OUTLINE to DBLINKUSR;
grant CREATE ANY PROCEDURE to DBLINKUSR;
grant CREATE ANY RULE SET to DBLINKUSR;
grant CREATE ANY RULE to DBLINKUSR;
grant CREATE ANY SEQUENCE to DBLINKUSR;
grant CREATE ANY SQL PROFILE to DBLINKUSR;
grant CREATE ANY SYNONYM to DBLINKUSR;
grant CREATE ANY TABLE to DBLINKUSR;
grant CREATE ANY TRIGGER to DBLINKUSR;
grant CREATE ANY TYPE to DBLINKUSR;
grant CREATE ANY VIEW to DBLINKUSR;
grant CREATE CLUSTER to DBLINKUSR;
grant CREATE DATABASE LINK to DBLINKUSR;
grant CREATE DIMENSION to DBLINKUSR;
grant CREATE EVALUATION CONTEXT to DBLINKUSR;
grant CREATE EXTERNAL JOB to DBLINKUSR;
grant CREATE INDEXTYPE to DBLINKUSR;
grant CREATE JOB to DBLINKUSR;
grant CREATE LIBRARY to DBLINKUSR;
grant CREATE MATERIALIZED VIEW to DBLINKUSR;
grant CREATE OPERATOR to DBLINKUSR;
grant CREATE PROCEDURE to DBLINKUSR;
grant CREATE PROFILE to DBLINKUSR;
grant CREATE PUBLIC DATABASE LINK to DBLINKUSR;
grant CREATE PUBLIC SYNONYM to DBLINKUSR;
grant CREATE ROLE to DBLINKUSR;
grant CREATE ROLLBACK SEGMENT to DBLINKUSR;
grant CREATE RULE SET to DBLINKUSR;
grant CREATE RULE to DBLINKUSR;
grant CREATE SEQUENCE to DBLINKUSR;
grant CREATE SESSION to DBLINKUSR;
grant CREATE SYNONYM to DBLINKUSR;
grant CREATE TABLE to DBLINKUSR;
grant CREATE TABLESPACE to DBLINKUSR;
grant CREATE TRIGGER to DBLINKUSR;
grant CREATE TYPE to DBLINKUSR;
grant CREATE USER to DBLINKUSR;
grant CREATE VIEW to DBLINKUSR;
grant DEBUG ANY PROCEDURE to DBLINKUSR;
grant DEBUG CONNECT SESSION to DBLINKUSR;
grant DELETE ANY TABLE to DBLINKUSR;
grant DEQUEUE ANY QUEUE to DBLINKUSR;
grant DROP ANY CLUSTER to DBLINKUSR;
grant DROP ANY CONTEXT to DBLINKUSR;
grant DROP ANY DIMENSION to DBLINKUSR;
grant DROP ANY DIRECTORY to DBLINKUSR;
grant DROP ANY EVALUATION CONTEXT to DBLINKUSR;
grant DROP ANY INDEX to DBLINKUSR;
grant DROP ANY INDEXTYPE to DBLINKUSR;
grant DROP ANY LIBRARY to DBLINKUSR;
grant DROP ANY MATERIALIZED VIEW to DBLINKUSR;
grant DROP ANY OPERATOR to DBLINKUSR;
grant DROP ANY OUTLINE to DBLINKUSR;
grant DROP ANY PROCEDURE to DBLINKUSR;
grant DROP ANY ROLE to DBLINKUSR;
grant DROP ANY RULE SET to DBLINKUSR;
grant DROP ANY RULE to DBLINKUSR;
grant DROP ANY SEQUENCE to DBLINKUSR;
grant DROP ANY SQL PROFILE to DBLINKUSR;
grant DROP ANY SYNONYM to DBLINKUSR;
grant DROP ANY TABLE to DBLINKUSR;
grant DROP ANY TRIGGER to DBLINKUSR;
grant DROP ANY TYPE to DBLINKUSR;
grant DROP ANY VIEW to DBLINKUSR;
grant DROP PROFILE to DBLINKUSR;
grant DROP PUBLIC DATABASE LINK to DBLINKUSR;
grant DROP PUBLIC SYNONYM to DBLINKUSR;
grant DROP ROLLBACK SEGMENT to DBLINKUSR;
grant DROP TABLESPACE to DBLINKUSR;
grant DROP USER to DBLINKUSR;
grant ENQUEUE ANY QUEUE to DBLINKUSR;
grant EXECUTE ANY CLASS to DBLINKUSR;
grant EXECUTE ANY EVALUATION CONTEXT to DBLINKUSR;
grant EXECUTE ANY INDEXTYPE to DBLINKUSR;
grant EXECUTE ANY LIBRARY to DBLINKUSR;
grant EXECUTE ANY OPERATOR to DBLINKUSR;
grant EXECUTE ANY PROCEDURE to DBLINKUSR;
grant EXECUTE ANY PROGRAM to DBLINKUSR;
grant EXECUTE ANY RULE SET to DBLINKUSR;
grant EXECUTE ANY RULE to DBLINKUSR;
grant EXECUTE ANY TYPE to DBLINKUSR;
grant EXPORT FULL DATABASE to DBLINKUSR;
grant FLASHBACK ANY TABLE to DBLINKUSR;
grant FORCE ANY TRANSACTION to DBLINKUSR;
grant FORCE TRANSACTION to DBLINKUSR;
grant GLOBAL QUERY REWRITE to DBLINKUSR;
grant GRANT ANY OBJECT PRIVILEGE to DBLINKUSR;
grant GRANT ANY PRIVILEGE to DBLINKUSR;
grant GRANT ANY ROLE to DBLINKUSR;
grant IMPORT FULL DATABASE to DBLINKUSR;
grant INSERT ANY TABLE to DBLINKUSR;
grant LOCK ANY TABLE to DBLINKUSR;
grant MANAGE ANY FILE GROUP to DBLINKUSR;
grant MANAGE ANY QUEUE to DBLINKUSR;
grant MANAGE FILE GROUP to DBLINKUSR;
grant MANAGE SCHEDULER to DBLINKUSR;
grant MANAGE TABLESPACE to DBLINKUSR;
grant MERGE ANY VIEW to DBLINKUSR;
grant ON COMMIT REFRESH to DBLINKUSR;
grant QUERY REWRITE to DBLINKUSR;
grant READ ANY FILE GROUP to DBLINKUSR;
grant RESTRICTED SESSION to DBLINKUSR;
grant RESUMABLE to DBLINKUSR;
grant SELECT ANY DICTIONARY to DBLINKUSR;
grant SELECT ANY SEQUENCE to DBLINKUSR;
grant SELECT ANY TABLE to DBLINKUSR;
grant SELECT ANY TRANSACTION to DBLINKUSR;
grant UNDER ANY TABLE to DBLINKUSR;
grant UNDER ANY TYPE to DBLINKUSR;
grant UNDER ANY VIEW to DBLINKUSR;
grant UNLIMITED TABLESPACE to DBLINKUSR;
grant UPDATE ANY TABLE to DBLINKUSR;
SQL> select ‘grant ‘|| privilege ||‘ to DBUSRMKT;‘ from dba_sys_privs where grantee=‘DBUSRMKT‘
union
select ‘grant ‘|| privilege ||‘ to DBUSRMKT;‘ from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee=‘DBUSRMKT‘ )
union
select ‘grant ‘|| privilege ||‘ to DBUSRMKT;‘ from dba_tab_privs where grantee=‘DBUSRMKT‘;
grant ADMINISTER ANY SQL TUNING SET to DBUSRMKT;
grant ADMINISTER DATABASE TRIGGER to DBUSRMKT;
grant ADMINISTER RESOURCE MANAGER to DBUSRMKT;
grant ADMINISTER SQL TUNING SET to DBUSRMKT;
grant ADVISOR to DBUSRMKT;
grant ALTER ANY CLUSTER to DBUSRMKT;
grant ALTER ANY DIMENSION to DBUSRMKT;
grant ALTER ANY EVALUATION CONTEXT to DBUSRMKT;
grant ALTER ANY INDEX to DBUSRMKT;
grant ALTER ANY INDEXTYPE to DBUSRMKT;
grant ALTER ANY LIBRARY to DBUSRMKT;
grant ALTER ANY MATERIALIZED VIEW to DBUSRMKT;
grant ALTER ANY OUTLINE to DBUSRMKT;
grant ALTER ANY PROCEDURE to DBUSRMKT;
grant ALTER ANY ROLE to DBUSRMKT;
grant ALTER ANY RULE SET to DBUSRMKT;
grant ALTER ANY RULE to DBUSRMKT;
grant ALTER ANY SEQUENCE to DBUSRMKT;
grant ALTER ANY SQL PROFILE to DBUSRMKT;
grant ALTER ANY TABLE to DBUSRMKT;
grant ALTER ANY TRIGGER to DBUSRMKT;
grant ALTER ANY TYPE to DBUSRMKT;
grant ALTER DATABASE to DBUSRMKT;
grant ALTER PROFILE to DBUSRMKT;
grant ALTER RESOURCE COST to DBUSRMKT;
grant ALTER ROLLBACK SEGMENT to DBUSRMKT;
grant ALTER SESSION to DBUSRMKT;
grant ALTER SYSTEM to DBUSRMKT;
grant ALTER TABLESPACE to DBUSRMKT;
grant ALTER USER to DBUSRMKT;
grant ANALYZE ANY DICTIONARY to DBUSRMKT;
grant ANALYZE ANY to DBUSRMKT;
grant AUDIT ANY to DBUSRMKT;
grant AUDIT SYSTEM to DBUSRMKT;
grant BACKUP ANY TABLE to DBUSRMKT;
grant BECOME USER to DBUSRMKT;
grant CHANGE NOTIFICATION to DBUSRMKT;
grant COMMENT ANY TABLE to DBUSRMKT;
grant CREATE ANY CLUSTER to DBUSRMKT;
grant CREATE ANY CONTEXT to DBUSRMKT;
grant CREATE ANY DIMENSION to DBUSRMKT;
grant CREATE ANY DIRECTORY to DBUSRMKT;
grant CREATE ANY EVALUATION CONTEXT to DBUSRMKT;
grant CREATE ANY INDEX to DBUSRMKT;
grant CREATE ANY INDEXTYPE to DBUSRMKT;
grant CREATE ANY JOB to DBUSRMKT;
grant CREATE ANY LIBRARY to DBUSRMKT;
grant CREATE ANY MATERIALIZED VIEW to DBUSRMKT;
grant CREATE ANY OPERATOR to DBUSRMKT;
grant CREATE ANY OUTLINE to DBUSRMKT;
grant CREATE ANY PROCEDURE to DBUSRMKT;
grant CREATE ANY RULE SET to DBUSRMKT;
grant CREATE ANY RULE to DBUSRMKT;
grant CREATE ANY SEQUENCE to DBUSRMKT;
grant CREATE ANY SQL PROFILE to DBUSRMKT;
grant CREATE ANY SYNONYM to DBUSRMKT;
grant CREATE ANY TABLE to DBUSRMKT;
grant CREATE ANY TRIGGER to DBUSRMKT;
grant CREATE ANY TYPE to DBUSRMKT;
grant CREATE ANY VIEW to DBUSRMKT;
grant CREATE CLUSTER to DBUSRMKT;
grant CREATE DATABASE LINK to DBUSRMKT;
grant CREATE DIMENSION to DBUSRMKT;
grant CREATE EVALUATION CONTEXT to DBUSRMKT;
grant CREATE EXTERNAL JOB to DBUSRMKT;
grant CREATE INDEXTYPE to DBUSRMKT;
grant CREATE JOB to DBUSRMKT;
grant CREATE LIBRARY to DBUSRMKT;
grant CREATE MATERIALIZED VIEW to DBUSRMKT;
grant CREATE OPERATOR to DBUSRMKT;
grant CREATE PROCEDURE to DBUSRMKT;
grant CREATE PROFILE to DBUSRMKT;
grant CREATE PUBLIC DATABASE LINK to DBUSRMKT;
grant CREATE PUBLIC SYNONYM to DBUSRMKT;
grant CREATE ROLE to DBUSRMKT;
grant CREATE ROLLBACK SEGMENT to DBUSRMKT;
grant CREATE RULE SET to DBUSRMKT;
grant CREATE RULE to DBUSRMKT;
grant CREATE SEQUENCE to DBUSRMKT;
grant CREATE SESSION to DBUSRMKT;
grant CREATE SYNONYM to DBUSRMKT;
grant CREATE TABLE to DBUSRMKT;
grant CREATE TABLESPACE to DBUSRMKT;
grant CREATE TRIGGER to DBUSRMKT;
grant CREATE TYPE to DBUSRMKT;
grant CREATE USER to DBUSRMKT;
grant CREATE VIEW to DBUSRMKT;
grant DEBUG ANY PROCEDURE to DBUSRMKT;
grant DEBUG CONNECT SESSION to DBUSRMKT;
grant DELETE ANY TABLE to DBUSRMKT;
grant DEQUEUE ANY QUEUE to DBUSRMKT;
grant DROP ANY CLUSTER to DBUSRMKT;
grant DROP ANY CONTEXT to DBUSRMKT;
grant DROP ANY DIMENSION to DBUSRMKT;
grant DROP ANY DIRECTORY to DBUSRMKT;
grant DROP ANY EVALUATION CONTEXT to DBUSRMKT;
grant DROP ANY INDEX to DBUSRMKT;
grant DROP ANY INDEXTYPE to DBUSRMKT;
grant DROP ANY LIBRARY to DBUSRMKT;
grant DROP ANY MATERIALIZED VIEW to DBUSRMKT;
grant DROP ANY OPERATOR to DBUSRMKT;
grant DROP ANY OUTLINE to DBUSRMKT;
grant DROP ANY PROCEDURE to DBUSRMKT;
grant DROP ANY ROLE to DBUSRMKT;
grant DROP ANY RULE SET to DBUSRMKT;
grant DROP ANY RULE to DBUSRMKT;
grant DROP ANY SEQUENCE to DBUSRMKT;
grant DROP ANY SQL PROFILE to DBUSRMKT;
grant DROP ANY SYNONYM to DBUSRMKT;
grant DROP ANY TABLE to DBUSRMKT;
grant DROP ANY TRIGGER to DBUSRMKT;
grant DROP ANY TYPE to DBUSRMKT;
grant DROP ANY VIEW to DBUSRMKT;
grant DROP PROFILE to DBUSRMKT;
grant DROP PUBLIC DATABASE LINK to DBUSRMKT;
grant DROP PUBLIC SYNONYM to DBUSRMKT;
grant DROP ROLLBACK SEGMENT to DBUSRMKT;
grant DROP TABLESPACE to DBUSRMKT;
grant DROP USER to DBUSRMKT;
grant ENQUEUE ANY QUEUE to DBUSRMKT;
grant EXECUTE ANY CLASS to DBUSRMKT;
grant EXECUTE ANY EVALUATION CONTEXT to DBUSRMKT;
grant EXECUTE ANY INDEXTYPE to DBUSRMKT;
grant EXECUTE ANY LIBRARY to DBUSRMKT;
grant EXECUTE ANY OPERATOR to DBUSRMKT;
grant EXECUTE ANY PROCEDURE to DBUSRMKT;
grant EXECUTE ANY PROGRAM to DBUSRMKT;
grant EXECUTE ANY RULE SET to DBUSRMKT;
grant EXECUTE ANY RULE to DBUSRMKT;
grant EXECUTE ANY TYPE to DBUSRMKT;
grant EXPORT FULL DATABASE to DBUSRMKT;
grant FLASHBACK ANY TABLE to DBUSRMKT;
grant FORCE ANY TRANSACTION to DBUSRMKT;
grant FORCE TRANSACTION to DBUSRMKT;
grant GLOBAL QUERY REWRITE to DBUSRMKT;
grant GRANT ANY OBJECT PRIVILEGE to DBUSRMKT;
grant GRANT ANY PRIVILEGE to DBUSRMKT;
grant GRANT ANY ROLE to DBUSRMKT;
grant IMPORT FULL DATABASE to DBUSRMKT;
grant INSERT ANY TABLE to DBUSRMKT;
grant LOCK ANY TABLE to DBUSRMKT;
grant MANAGE ANY FILE GROUP to DBUSRMKT;
grant MANAGE ANY QUEUE to DBUSRMKT;
grant MANAGE FILE GROUP to DBUSRMKT;
grant MANAGE SCHEDULER to DBUSRMKT;
grant MANAGE TABLESPACE to DBUSRMKT;
grant MERGE ANY VIEW to DBUSRMKT;
grant ON COMMIT REFRESH to DBUSRMKT;
grant QUERY REWRITE to DBUSRMKT;
grant READ ANY FILE GROUP to DBUSRMKT;
grant RESTRICTED SESSION to DBUSRMKT;
grant RESUMABLE to DBUSRMKT;
grant SELECT ANY DICTIONARY to DBUSRMKT;
grant SELECT ANY SEQUENCE to DBUSRMKT;
grant SELECT ANY TABLE to DBUSRMKT;
grant SELECT ANY TRANSACTION to DBUSRMKT;
grant UNDER ANY TABLE to DBUSRMKT;
grant UNDER ANY TYPE to DBUSRMKT;
grant UNDER ANY VIEW to DBUSRMKT;
grant UNLIMITED TABLESPACE to DBUSRMKT;
grant UPDATE ANY TABLE to DBUSRMKT;
SQL> select ‘grant ‘|| privilege ||‘ to DBUSRPOP;‘ from dba_sys_privs where grantee=‘DBUSRPOP‘
union
select ‘grant ‘|| privilege ||‘ to DBUSRPOP;‘ from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee=‘DBUSRPOP‘ )
union
select ‘grant ‘|| privilege ||‘ to DBUSRPOP;‘ from dba_tab_privs where grantee=‘DBUSRPOP‘;
grant ADMINISTER ANY SQL TUNING SET to DBUSRPOP;
grant ADMINISTER DATABASE TRIGGER to DBUSRPOP;
grant ADMINISTER RESOURCE MANAGER to DBUSRPOP;
grant ADMINISTER SQL TUNING SET to DBUSRPOP;
grant ADVISOR to DBUSRPOP;
grant ALTER ANY CLUSTER to DBUSRPOP;
grant ALTER ANY DIMENSION to DBUSRPOP;
grant ALTER ANY EVALUATION CONTEXT to DBUSRPOP;
grant ALTER ANY INDEX to DBUSRPOP;
grant ALTER ANY INDEXTYPE to DBUSRPOP;
grant ALTER ANY LIBRARY to DBUSRPOP;
grant ALTER ANY MATERIALIZED VIEW to DBUSRPOP;
grant ALTER ANY OUTLINE to DBUSRPOP;
grant ALTER ANY PROCEDURE to DBUSRPOP;
grant ALTER ANY ROLE to DBUSRPOP;
grant ALTER ANY RULE SET to DBUSRPOP;
grant ALTER ANY RULE to DBUSRPOP;
grant ALTER ANY SEQUENCE to DBUSRPOP;
grant ALTER ANY SQL PROFILE to DBUSRPOP;
grant ALTER ANY TABLE to DBUSRPOP;
grant ALTER ANY TRIGGER to DBUSRPOP;
grant ALTER ANY TYPE to DBUSRPOP;
grant ALTER DATABASE to DBUSRPOP;
grant ALTER PROFILE to DBUSRPOP;
grant ALTER RESOURCE COST to DBUSRPOP;
grant ALTER ROLLBACK SEGMENT to DBUSRPOP;
grant ALTER SESSION to DBUSRPOP;
grant ALTER SYSTEM to DBUSRPOP;
grant ALTER TABLESPACE to DBUSRPOP;
grant ALTER USER to DBUSRPOP;
grant ANALYZE ANY DICTIONARY to DBUSRPOP;
grant ANALYZE ANY to DBUSRPOP;
grant AUDIT ANY to DBUSRPOP;
grant AUDIT SYSTEM to DBUSRPOP;
grant BACKUP ANY TABLE to DBUSRPOP;
grant BECOME USER to DBUSRPOP;
grant CHANGE NOTIFICATION to DBUSRPOP;
grant COMMENT ANY TABLE to DBUSRPOP;
grant CREATE ANY CLUSTER to DBUSRPOP;
grant CREATE ANY CONTEXT to DBUSRPOP;
grant CREATE ANY DIMENSION to DBUSRPOP;
grant CREATE ANY DIRECTORY to DBUSRPOP;
grant CREATE ANY EVALUATION CONTEXT to DBUSRPOP;
grant CREATE ANY INDEX to DBUSRPOP;
grant CREATE ANY INDEXTYPE to DBUSRPOP;
grant CREATE ANY JOB to DBUSRPOP;
grant CREATE ANY LIBRARY to DBUSRPOP;
grant CREATE ANY MATERIALIZED VIEW to DBUSRPOP;
grant CREATE ANY OPERATOR to DBUSRPOP;
grant CREATE ANY OUTLINE to DBUSRPOP;
grant CREATE ANY PROCEDURE to DBUSRPOP;
grant CREATE ANY RULE SET to DBUSRPOP;
grant CREATE ANY RULE to DBUSRPOP;
grant CREATE ANY SEQUENCE to DBUSRPOP;
grant CREATE ANY SQL PROFILE to DBUSRPOP;
grant CREATE ANY SYNONYM to DBUSRPOP;
grant CREATE ANY TABLE to DBUSRPOP;
grant CREATE ANY TRIGGER to DBUSRPOP;
grant CREATE ANY TYPE to DBUSRPOP;
grant CREATE ANY VIEW to DBUSRPOP;
grant CREATE CLUSTER to DBUSRPOP;
grant CREATE DATABASE LINK to DBUSRPOP;
grant CREATE DIMENSION to DBUSRPOP;
grant CREATE EVALUATION CONTEXT to DBUSRPOP;
grant CREATE EXTERNAL JOB to DBUSRPOP;
grant CREATE INDEXTYPE to DBUSRPOP;
grant CREATE JOB to DBUSRPOP;
grant CREATE LIBRARY to DBUSRPOP;
grant CREATE MATERIALIZED VIEW to DBUSRPOP;
grant CREATE OPERATOR to DBUSRPOP;
grant CREATE PROCEDURE to DBUSRPOP;
grant CREATE PROFILE to DBUSRPOP;
grant CREATE PUBLIC DATABASE LINK to DBUSRPOP;
grant CREATE PUBLIC SYNONYM to DBUSRPOP;
grant CREATE ROLE to DBUSRPOP;
grant CREATE ROLLBACK SEGMENT to DBUSRPOP;
grant CREATE RULE SET to DBUSRPOP;
grant CREATE RULE to DBUSRPOP;
grant CREATE SEQUENCE to DBUSRPOP;
grant CREATE SESSION to DBUSRPOP;
grant CREATE SYNONYM to DBUSRPOP;
grant CREATE TABLE to DBUSRPOP;
grant CREATE TABLESPACE to DBUSRPOP;
grant CREATE TRIGGER to DBUSRPOP;
grant CREATE TYPE to DBUSRPOP;
grant CREATE USER to DBUSRPOP;
grant CREATE VIEW to DBUSRPOP;
grant DEBUG ANY PROCEDURE to DBUSRPOP;
grant DEBUG CONNECT SESSION to DBUSRPOP;
grant DELETE ANY TABLE to DBUSRPOP;
grant DEQUEUE ANY QUEUE to DBUSRPOP;
grant DROP ANY CLUSTER to DBUSRPOP;
grant DROP ANY CONTEXT to DBUSRPOP;
grant DROP ANY DIMENSION to DBUSRPOP;
grant DROP ANY DIRECTORY to DBUSRPOP;
grant DROP ANY EVALUATION CONTEXT to DBUSRPOP;
grant DROP ANY INDEX to DBUSRPOP;
grant DROP ANY INDEXTYPE to DBUSRPOP;
grant DROP ANY LIBRARY to DBUSRPOP;
grant DROP ANY MATERIALIZED VIEW to DBUSRPOP;
grant DROP ANY OPERATOR to DBUSRPOP;
grant DROP ANY OUTLINE to DBUSRPOP;
grant DROP ANY PROCEDURE to DBUSRPOP;
grant DROP ANY ROLE to DBUSRPOP;
grant DROP ANY RULE SET to DBUSRPOP;
grant DROP ANY RULE to DBUSRPOP;
grant DROP ANY SEQUENCE to DBUSRPOP;
grant DROP ANY SQL PROFILE to DBUSRPOP;
grant DROP ANY SYNONYM to DBUSRPOP;
grant DROP ANY TABLE to DBUSRPOP;
grant DROP ANY TRIGGER to DBUSRPOP;
grant DROP ANY TYPE to DBUSRPOP;
grant DROP ANY VIEW to DBUSRPOP;
grant DROP PROFILE to DBUSRPOP;
grant DROP PUBLIC DATABASE LINK to DBUSRPOP;
grant DROP PUBLIC SYNONYM to DBUSRPOP;
grant DROP ROLLBACK SEGMENT to DBUSRPOP;
grant DROP TABLESPACE to DBUSRPOP;
grant DROP USER to DBUSRPOP;
grant ENQUEUE ANY QUEUE to DBUSRPOP;
grant EXECUTE ANY CLASS to DBUSRPOP;
grant EXECUTE ANY EVALUATION CONTEXT to DBUSRPOP;
grant EXECUTE ANY INDEXTYPE to DBUSRPOP;
grant EXECUTE ANY LIBRARY to DBUSRPOP;
grant EXECUTE ANY OPERATOR to DBUSRPOP;
grant EXECUTE ANY PROCEDURE to DBUSRPOP;
grant EXECUTE ANY PROGRAM to DBUSRPOP;
grant EXECUTE ANY RULE SET to DBUSRPOP;
grant EXECUTE ANY RULE to DBUSRPOP;
grant EXECUTE ANY TYPE to DBUSRPOP;
grant EXPORT FULL DATABASE to DBUSRPOP;
grant FLASHBACK ANY TABLE to DBUSRPOP;
grant FORCE ANY TRANSACTION to DBUSRPOP;
grant FORCE TRANSACTION to DBUSRPOP;
grant GLOBAL QUERY REWRITE to DBUSRPOP;
grant GRANT ANY OBJECT PRIVILEGE to DBUSRPOP;
grant GRANT ANY PRIVILEGE to DBUSRPOP;
grant GRANT ANY ROLE to DBUSRPOP;
grant IMPORT FULL DATABASE to DBUSRPOP;
grant INSERT ANY TABLE to DBUSRPOP;
grant LOCK ANY TABLE to DBUSRPOP;
grant MANAGE ANY FILE GROUP to DBUSRPOP;
grant MANAGE ANY QUEUE to DBUSRPOP;
grant MANAGE FILE GROUP to DBUSRPOP;
grant MANAGE SCHEDULER to DBUSRPOP;
grant MANAGE TABLESPACE to DBUSRPOP;
grant MERGE ANY VIEW to DBUSRPOP;
grant ON COMMIT REFRESH to DBUSRPOP;
grant QUERY REWRITE to DBUSRPOP;
grant READ ANY FILE GROUP to DBUSRPOP;
grant RESTRICTED SESSION to DBUSRPOP;
grant RESUMABLE to DBUSRPOP;
grant SELECT ANY DICTIONARY to DBUSRPOP;
grant SELECT ANY SEQUENCE to DBUSRPOP;
grant SELECT ANY TABLE to DBUSRPOP;
grant SELECT ANY TRANSACTION to DBUSRPOP;
grant UNDER ANY TABLE to DBUSRPOP;
grant UNDER ANY TYPE to DBUSRPOP;
grant UNDER ANY VIEW to DBUSRPOP;
grant UNLIMITED TABLESPACE to DBUSRPOP;
grant UPDATE ANY TABLE to DBUSRPOP;
SQL> select ‘grant ‘|| privilege ||‘ to DBUSRPUB;‘ from dba_sys_privs where grantee=‘DBUSRPUB‘
union
select ‘grant ‘|| privilege ||‘ to DBUSRPUB;‘ from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee=‘DBUSRPUB‘ )
union
select ‘grant ‘|| privilege ||‘ to DBUSRPUB;‘ from dba_tab_privs where grantee=‘DBUSRPUB‘;
grant ADMINISTER ANY SQL TUNING SET to DBUSRPUB;
grant ADMINISTER DATABASE TRIGGER to DBUSRPUB;
grant ADMINISTER RESOURCE MANAGER to DBUSRPUB;
grant ADMINISTER SQL TUNING SET to DBUSRPUB;
grant ADVISOR to DBUSRPUB;
grant ALTER ANY CLUSTER to DBUSRPUB;
grant ALTER ANY DIMENSION to DBUSRPUB;
grant ALTER ANY EVALUATION CONTEXT to DBUSRPUB;
grant ALTER ANY INDEX to DBUSRPUB;
grant ALTER ANY INDEXTYPE to DBUSRPUB;
grant ALTER ANY LIBRARY to DBUSRPUB;
grant ALTER ANY MATERIALIZED VIEW to DBUSRPUB;
grant ALTER ANY OUTLINE to DBUSRPUB;
grant ALTER ANY PROCEDURE to DBUSRPUB;
grant ALTER ANY ROLE to DBUSRPUB;
grant ALTER ANY RULE SET to DBUSRPUB;
grant ALTER ANY RULE to DBUSRPUB;
grant ALTER ANY SEQUENCE to DBUSRPUB;
grant ALTER ANY SQL PROFILE to DBUSRPUB;
grant ALTER ANY TABLE to DBUSRPUB;
grant ALTER ANY TRIGGER to DBUSRPUB;
grant ALTER ANY TYPE to DBUSRPUB;
grant ALTER DATABASE to DBUSRPUB;
grant ALTER PROFILE to DBUSRPUB;
grant ALTER RESOURCE COST to DBUSRPUB;
grant ALTER ROLLBACK SEGMENT to DBUSRPUB;
grant ALTER SESSION to DBUSRPUB;
grant ALTER SYSTEM to DBUSRPUB;
grant ALTER TABLESPACE to DBUSRPUB;
grant ALTER USER to DBUSRPUB;
grant ANALYZE ANY DICTIONARY to DBUSRPUB;
grant ANALYZE ANY to DBUSRPUB;
grant AUDIT ANY to DBUSRPUB;
grant AUDIT SYSTEM to DBUSRPUB;
grant BACKUP ANY TABLE to DBUSRPUB;
grant BECOME USER to DBUSRPUB;
grant CHANGE NOTIFICATION to DBUSRPUB;
grant COMMENT ANY TABLE to DBUSRPUB;
grant CREATE ANY CLUSTER to DBUSRPUB;
grant CREATE ANY CONTEXT to DBUSRPUB;
grant CREATE ANY DIMENSION to DBUSRPUB;
grant CREATE ANY DIRECTORY to DBUSRPUB;
grant CREATE ANY EVALUATION CONTEXT to DBUSRPUB;
grant CREATE ANY INDEX to DBUSRPUB;
grant CREATE ANY INDEXTYPE to DBUSRPUB;
grant CREATE ANY JOB to DBUSRPUB;
grant CREATE ANY LIBRARY to DBUSRPUB;
grant CREATE ANY MATERIALIZED VIEW to DBUSRPUB;
grant CREATE ANY OPERATOR to DBUSRPUB;
grant CREATE ANY OUTLINE to DBUSRPUB;
grant CREATE ANY PROCEDURE to DBUSRPUB;
grant CREATE ANY RULE SET to DBUSRPUB;
grant CREATE ANY RULE to DBUSRPUB;
grant CREATE ANY SEQUENCE to DBUSRPUB;
grant CREATE ANY SQL PROFILE to DBUSRPUB;
grant CREATE ANY SYNONYM to DBUSRPUB;
grant CREATE ANY TABLE to DBUSRPUB;
grant CREATE ANY TRIGGER to DBUSRPUB;
grant CREATE ANY TYPE to DBUSRPUB;
grant CREATE ANY VIEW to DBUSRPUB;
grant CREATE CLUSTER to DBUSRPUB;
grant CREATE DATABASE LINK to DBUSRP