CREATE USER GGATE

IDENTIFIED BY <password>
DEFAULT TABLESPACE GGATE_DATA
TEMPORARY TABLESPACE TEMP01
PROFILE DEFAULT
ACCOUNT UNLOCK;

-- 5 Roles for GGATE

GRANT CONNECT TO GGATE;
GRANT DBA TO GGATE;
GRANT RESOURCE TO GGATE;
GRANT SELECT_CATALOG_ROLE TO GGATE;
GRANT XDBADMIN TO GGATE;
ALTER USER GGATE DEFAULT ROLE ALL;

-- 26 System Privileges for GGATE

GRANT ALTER ANY TABLE TO GGATE;
GRANT ALTER SESSION TO GGATE;
GRANT ALTER SYSTEM TO GGATE;
GRANT CREATE ANY TABLE TO GGATE;
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ,
GRANTEE => 'GGATE',
GRANT_OPTION => TRUE);
END;
/
GRANT CREATE JOB TO GGATE;
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ,
GRANTEE => 'GGATE',
GRANT_OPTION => TRUE);
END;
/
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ,
GRANTEE => 'GGATE',
GRANT_OPTION => TRUE);
END;
/
GRANT CREATE SESSION TO GGATE;
GRANT CREATE TABLE TO GGATE;
GRANT DELETE ANY TABLE TO GGATE;
BEGIN
SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE (
PRIVILEGE => 'DEQUEUE_ANY',
GRANTEE => 'GGATE',
ADMIN_OPTION => TRUE);
END;
/
GRANT DROP ANY TABLE TO GGATE;
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE_SET,
GRANTEE => 'GGATE',
GRANT_OPTION => TRUE);
END;
/
GRANT EXEMPT ACCESS POLICY TO GGATE;
GRANT EXEMPT IDENTITY POLICY TO GGATE;
GRANT EXEMPT REDACTION POLICY TO GGATE;
GRANT FLASHBACK ANY TABLE TO GGATE;
GRANT INSERT ANY TABLE TO GGATE;
GRANT LOCK ANY TABLE TO GGATE;
GRANT LOGMINING TO GGATE;
GRANT SELECT ANY DICTIONARY TO GGATE;
GRANT SELECT ANY TABLE TO GGATE;
GRANT SELECT ANY TRANSACTION TO GGATE;
GRANT UNLIMITED TABLESPACE TO GGATE;
GRANT UPDATE ANY TABLE TO GGATE;

-- 1 Tablespace Quota for GGATE

ALTER USER GGATE QUOTA UNLIMITED ON GGATE_DATA;

-- 182 Object Privileges for GGATE

GRANT SELECT ON SYS.ALL_APPLY TO GGATE;
GRANT SELECT ON SYS.ALL_APPLY_KEY_COLUMNS TO GGATE;
GRANT SELECT ON SYS.ALL_APPLY_PARAMETERS TO GGATE;
GRANT SELECT ON SYS.ALL_APPLY_PROGRESS TO GGATE;
GRANT SELECT ON SYS.ALL_APPLY_TABLE_COLUMNS TO GGATE;
GRANT SELECT ON SYS.ALL_CAPTURE TO GGATE;
GRANT SELECT ON SYS.ALL_CAPTURE_EXTRA_ATTRIBUTES TO GGATE;
GRANT SELECT ON SYS.ALL_CAPTURE_PARAMETERS TO GGATE;
GRANT SELECT ON SYS.ALL_CAPTURE_PREPARED_DATABASE TO GGATE;
GRANT SELECT ON SYS.ALL_CAPTURE_PREPARED_SCHEMAS TO GGATE;
GRANT SELECT ON SYS.ALL_CAPTURE_PREPARED_TABLES TO GGATE;
GRANT SELECT ON SYS.ALL_COMPARISON_SCAN_SUMMARY TO GGATE;
GRANT SELECT ON SYS.ALL_DB_LINKS TO GGATE;
GRANT SELECT ON SYS.ALL_EVALUATION_CONTEXTS TO GGATE;
GRANT SELECT ON SYS.ALL_EVALUATION_CONTEXT_TABLES TO GGATE;
GRANT SELECT ON SYS.ALL_EVALUATION_CONTEXT_VARS TO GGATE;
GRANT SELECT ON SYS.ALL_GOLDENGATE_PRIVILEGES TO GGATE;
GRANT SELECT ON SYS.ALL_GOLDENGATE_RULES TO GGATE;
GRANT SELECT ON SYS.ALL_QUEUES TO GGATE;
GRANT SELECT ON SYS.ALL_QUEUE_SUBSCRIBERS TO GGATE;
GRANT SELECT ON SYS.ALL_QUEUE_TABLES TO GGATE;
GRANT SELECT ON SYS.ALL_REPL_DBNAME_MAPPING TO GGATE;
GRANT SELECT ON SYS.ALL_RULES TO GGATE;
GRANT SELECT ON SYS.ALL_RULESETS TO GGATE;
GRANT SELECT ON SYS.ALL_RULE_SETS TO GGATE;
GRANT SELECT ON SYS.ALL_RULE_SET_RULES TO GGATE;
GRANT SELECT ON SYS.ALL_SCHEDULER_JOBS TO GGATE;
GRANT SELECT ON SYS.ALL_STREAMS_COLUMNS TO GGATE;
GRANT SELECT ON SYS.ALL_STREAMS_GLOBAL_RULES TO GGATE;
GRANT SELECT ON SYS.ALL_STREAMS_KEEP_COLUMNS TO GGATE;
GRANT SELECT ON SYS.ALL_STREAMS_RULES TO GGATE;
GRANT SELECT ON SYS.ALL_STREAMS_SCHEMA_RULES TO GGATE;
GRANT SELECT ON SYS.ALL_STREAMS_TABLE_RULES TO GGATE;
GRANT SELECT ON SYS.ALL_STREAMS_TRANSFORMATIONS TO GGATE;
GRANT SELECT ON SYS.ALL_XSTREAM_OUTBOUND TO GGATE;
GRANT SELECT ON SYS.ALL_XSTREAM_OUTBOUND_PROGRESS TO GGATE;
GRANT SELECT ON SYS.ALL_XSTREAM_OUT_SUPPORT_MODE TO GGATE;
GRANT SELECT ON SYS.ALL_XSTREAM_RULES TO GGATE;
GRANT SELECT ON SYS.AQ$_UNFLUSHED_DEQUEUES TO GGATE;
GRANT SELECT ON SYS.AQ_EVENT_TABLE TO GGATE;
GRANT SELECT ON SYS.CDEF$ TO GGATE;
GRANT SELECT ON SYS.COL$ TO GGATE;
GRANT SELECT ON SYS.CON$ TO GGATE;
GRANT SELECT ON SYS.DBA_APPLY TO GGATE;
GRANT SELECT ON SYS.DBA_CAPTURE TO GGATE;
GRANT SELECT ON SYS.DBA_CLUSTERS TO GGATE;
GRANT SELECT ON SYS.DBA_COMPARISON_SCAN_SUMMARY TO GGATE;
GRANT SELECT ON SYS.DBA_DB_LINKS TO GGATE;
GRANT SELECT ON SYS.DBA_GOLDENGATE_PRIVILEGES TO GGATE;
GRANT SELECT ON SYS.DBA_GOLDENGATE_RULES TO GGATE;
GRANT SELECT ON SYS.DBA_GOLDENGATE_SUPPORT_MODE TO GGATE;
GRANT SELECT ON SYS.DBA_LOGMNR_SESSION TO GGATE;
GRANT SELECT ON SYS.DBA_OBJECTS TO GGATE;
GRANT SELECT ON SYS.DBA_QUEUES TO GGATE;
GRANT SELECT ON SYS.DBA_RECOVERABLE_SCRIPT TO GGATE;
GRANT SELECT ON SYS.DBA_RECOVERABLE_SCRIPT_BLOCKS TO GGATE;
GRANT SELECT ON SYS.DBA_RECOVERABLE_SCRIPT_ERRORS TO GGATE;
GRANT SELECT ON SYS.DBA_RECOVERABLE_SCRIPT_HIST TO GGATE;
GRANT SELECT ON SYS.DBA_RECOVERABLE_SCRIPT_PARAMS TO GGATE;
GRANT SELECT ON SYS.DBA_REGISTERED_ARCHIVED_LOG TO GGATE;
GRANT SELECT ON SYS.DBA_SCHEDULER_JOBS TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_COLUMNS TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_KEEP_COLUMNS TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_SPLIT_MERGE TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_SPLIT_MERGE_HIST TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_TP_COMPONENT TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_TP_COMPONENT_LINK TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_TP_COMPONENT_STAT TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_TP_DATABASE TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_TP_PATH_BOTTLENECK TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_TP_PATH_STAT TO GGATE;
GRANT SELECT ON SYS.DBA_STREAMS_TRANSFORMATIONS TO GGATE;
GRANT SELECT ON SYS.DBA_XSTREAM_OUTBOUND TO GGATE;
GRANT SELECT ON SYS.DBA_XSTREAM_OUTBOUND_PROGRESS TO GGATE;
GRANT SELECT ON SYS.DBA_XSTREAM_OUT_SUPPORT_MODE TO GGATE;
GRANT SELECT ON SYS.DBA_XSTREAM_RULES TO GGATE;
GRANT SELECT ON SYS.DBA_XSTREAM_SPLIT_MERGE TO GGATE;
GRANT SELECT ON SYS.DBA_XSTREAM_SPLIT_MERGE_HIST TO GGATE;
GRANT EXECUTE ON SYS.DBMS_APPLY_ADM TO GGATE;
GRANT EXECUTE ON SYS.DBMS_AQ TO GGATE;
GRANT EXECUTE ON SYS.DBMS_AQADM TO GGATE;
GRANT EXECUTE ON SYS.DBMS_AQIN TO GGATE;
GRANT EXECUTE ON SYS.DBMS_AQ_BQVIEW TO GGATE;
GRANT EXECUTE ON SYS.DBMS_CAPTURE_ADM TO GGATE;
GRANT EXECUTE ON SYS.DBMS_CAPTURE_SWITCH_ADM TO GGATE;
GRANT EXECUTE ON SYS.DBMS_COMPARISON TO GGATE;
GRANT EXECUTE ON SYS.DBMS_FLASHBACK TO GGATE;
GRANT EXECUTE ON SYS.DBMS_LCR TO GGATE;
GRANT EXECUTE ON SYS.DBMS_LOCK TO GGATE;
GRANT EXECUTE ON SYS.DBMS_LOGMNR_D TO GGATE;
GRANT EXECUTE ON SYS.DBMS_LOGREP_EXP TO GGATE;
GRANT EXECUTE ON SYS.DBMS_LOGREP_IMP TO GGATE;
GRANT EXECUTE ON SYS.DBMS_REPUTIL TO GGATE;
GRANT EXECUTE ON SYS.DBMS_REPUTIL2 TO GGATE;
GRANT EXECUTE ON SYS.DBMS_RULE_ADM TO GGATE;
GRANT EXECUTE ON SYS.DBMS_STREAMS TO GGATE;
GRANT EXECUTE ON SYS.DBMS_STREAMS_ADM TO GGATE;
GRANT EXECUTE ON SYS.DBMS_STREAMS_ADM_UTL_INVOK TO GGATE;
GRANT EXECUTE ON SYS.DBMS_STREAMS_ADVISOR_ADM TO GGATE;
GRANT EXECUTE ON SYS.DBMS_STREAMS_PUB_RPC TO GGATE;
GRANT EXECUTE ON SYS.DBMS_STREAMS_RPC TO GGATE;
GRANT EXECUTE ON SYS.DBMS_XSTREAM_ADM TO GGATE;
GRANT EXECUTE ON SYS.DBMS_XSTREAM_GG TO GGATE;
GRANT EXECUTE ON SYS.DBMS_XSTREAM_GG_ADM TO GGATE;
GRANT SELECT ON SYS.ENC$ TO GGATE;
GRANT SELECT ON SYS.GV_$AQ TO GGATE;
GRANT SELECT ON SYS.GV_$ARCHIVE_DEST TO GGATE;
GRANT SELECT ON SYS.GV_$BUFFERED_PUBLISHERS TO GGATE;
GRANT SELECT ON SYS.GV_$BUFFERED_QUEUES TO GGATE;
GRANT SELECT ON SYS.GV_$BUFFERED_SUBSCRIBERS TO GGATE;
GRANT SELECT ON SYS.GV_$DATABASE TO GGATE;
GRANT SELECT ON SYS.GV_$DATABASE_INCARNATION TO GGATE;
GRANT SELECT ON SYS.GV_$GOLDENGATE_CAPTURE TO GGATE;
GRANT SELECT ON SYS.GV_$GOLDENGATE_MESSAGETRACKING TO GGATE;
GRANT SELECT ON SYS.GV_$GOLDENGATE_TRANSACTION TO GGATE;
GRANT SELECT ON SYS.GV_$INSTANCE TO GGATE;
GRANT SELECT ON SYS.GV_$LOG TO GGATE;
GRANT SELECT ON SYS.GV_$LOGMNR_SESSION TO GGATE;
GRANT SELECT ON SYS.GV_$LOGMNR_STATS TO GGATE;
GRANT SELECT ON SYS.GV_$PARAMETER TO GGATE;
GRANT SELECT ON SYS.GV_$STREAMS_CAPTURE TO GGATE;
GRANT SELECT ON SYS.GV_$STREAMS_MESSAGE_TRACKING TO GGATE;
GRANT SELECT ON SYS.GV_$STREAMS_POOL_STATISTICS TO GGATE;
GRANT SELECT ON SYS.GV_$XSTREAM_OUTBOUND_SERVER TO GGATE;
GRANT EXECUTE ON SYS.LCR$_ROW_LIST TO GGATE;
GRANT EXECUTE ON SYS.LCR$_ROW_UNIT TO GGATE;
GRANT SELECT ON SYS.LOGMNR_BUILDLOG TO GGATE;
GRANT SELECT ON SYS.NTAB$ TO GGATE;
GRANT SELECT ON SYS.OBJ$ TO GGATE;
GRANT SELECT ON SYS.PROPS$ TO GGATE;
GRANT SELECT ON SYS.QT462204_BUFFER TO GGATE;
GRANT SELECT ON SYS.QT463503_BUFFER TO GGATE;
GRANT SELECT ON SYS.SEG$ TO GGATE;
GRANT SELECT ON SYS.SEQ$ TO GGATE;
GRANT SELECT ON SYS.STREAMS$_APPLY_PROCESS TO GGATE;
GRANT UPDATE ON SYS.STREAMS$_CAPTURE_PROCESS TO GGATE;
GRANT SELECT ON SYS.STREAMS$_MESSAGE_CONSUMERS TO GGATE;
GRANT SELECT ON SYS.STREAMS$_PREPARE_OBJECT TO GGATE;
GRANT SELECT ON SYS.TAB$ TO GGATE;
GRANT SELECT ON SYS.TS$ TO GGATE;
GRANT SELECT ON SYS.USER$ TO GGATE;
GRANT SELECT ON SYS.USER_GOLDENGATE_PRIVILEGES TO GGATE;
GRANT EXECUTE ON SYS.UTL_FILE TO GGATE;
GRANT SELECT ON SYS.VIEW$ TO GGATE;
GRANT SELECT ON SYS.V_$AQ TO GGATE;
GRANT SELECT ON SYS.V_$ARCHIVE_DEST TO GGATE;
GRANT SELECT ON SYS.V_$BUFFERED_PUBLISHERS TO GGATE;
GRANT SELECT ON SYS.V_$BUFFERED_QUEUES TO GGATE;
GRANT SELECT ON SYS.V_$BUFFERED_SUBSCRIBERS TO GGATE;
GRANT SELECT ON SYS.V_$DATABASE TO GGATE;
GRANT SELECT ON SYS.V_$DATABASE_INCARNATION TO GGATE;
GRANT SELECT ON SYS.V_$GOLDENGATE_CAPTURE TO GGATE;
GRANT SELECT ON SYS.V_$GOLDENGATE_MESSAGE_TRACKING TO GGATE;
GRANT SELECT ON SYS.V_$GOLDENGATE_TRANSACTION TO GGATE;
GRANT SELECT ON SYS.V_$INSTANCE TO GGATE;
GRANT SELECT ON SYS.V_$LOG TO GGATE;
GRANT SELECT ON SYS.V_$PARAMETER TO GGATE;
GRANT SELECT ON SYS.V_$PROPAGATION_RECEIVER TO GGATE;
GRANT SELECT ON SYS.V_$PROPAGATION_SENDER TO GGATE;
GRANT SELECT ON SYS.V_$RULE TO GGATE;
GRANT SELECT ON SYS.V_$RULE_SET TO GGATE;
GRANT SELECT ON SYS.V_$SESSION TO GGATE;
GRANT SELECT ON SYS.V_$STREAMS_CAPTURE TO GGATE;
GRANT SELECT ON SYS.V_$STREAMS_MESSAGE_TRACKING TO GGATE;
GRANT SELECT ON SYS.V_$STREAMS_POOL_STATISTICS TO GGATE;
GRANT SELECT ON SYS.V_$XSTREAM_OUTBOUND_SERVER TO GGATE;
GRANT SELECT ON SYS."_BASE_USER" TO GGATE;
GRANT SELECT ON SYS."_DBA_STREAMS_COMPONENT" TO GGATE;
GRANT SELECT ON SYS."_DBA_STREAMS_COMPONENT_EVENT" TO GGATE;
GRANT SELECT ON SYS."_DBA_STREAMS_COMPONENT_LINK" TO GGATE;
GRANT SELECT ON SYS."_DBA_STREAMS_COMPONENT_PROP" TO GGATE;
GRANT SELECT ON SYS."_DBA_STREAMS_COMPONENT_STAT" TO GGATE;
GRANT SELECT ON SYS."_DBA_STREAMS_TP_COMPONENT_PROP" TO GGATE;
GRANT SELECT ON SYS."_GV$SXGG_CAPTURE" TO GGATE;
GRANT SELECT ON SYS."_GV$SXGG_MESSAGE_TRACKING" TO GGATE;
GRANT SELECT ON SYS."_V$SXGG_CAPTURE" TO GGATE;
GRANT SELECT ON SYS."_V$SXGG_MESSAGE_TRACKING" TO GGATE;
GRANT EXECUTE ON SYSTEM.LOGMNR$COL_GG_TABF_PUBLIC TO GGATE;
GRANT EXECUTE ON SYSTEM.LOGMNR$KEY_GG_TABF_PUBLIC TO GGATE;
GRANT EXECUTE ON SYSTEM.LOGMNR$SEQ_GG_TABF_PUBLIC TO GGATE;
GRANT EXECUTE ON SYSTEM.LOGMNR$TAB_GG_TABF_PUBLIC TO GGATE;
GRANT INSERT ON SYSTEM.LOGMNR_RESTART_CKPT$ TO GGATE;