CDC Install

/* _______________________________________________________ {COPYRIGHT-TOP} _____

** Licensed Materials - Property of IBM

** IBM InfoSphere Change Data Capture

** 5724-U70

**

** (c) Copyright IBM Corp. 2001, 2011 All rights reserved.

**

** The following sample of source code ("Sample") is owned by International

** Business Machines Corporation or one of its subsidiaries ("IBM") and is

** copyrighted and licensed, not sold. You may use, copy, modify, and

** distribute the Sample in any form without payment to IBM.

**

** The Sample code is provided to you on an "AS IS" basis, without warranty of

** any kind. IBM HEREBY EXPRESSLY DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR

** IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF

** MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Some jurisdictions do

** not allow for the exclusion or limitation of implied warranties, so the above

** limitations or exclusions may not apply to you. IBM shall not be liable for

** any damages you suffer as a result of using, copying, modifying or

** distributing the Sample, even if IBM has been advised of the possibility of

** such damages.

 * ________________________________________________________ {COPYRIGHT-END} _____*/

--This script does not grant dba to the cdc user.

CREATE USER ibmcdc IDENTIFIED BY "&1"

PROFILE &profile

DEFAULT TABLESPACE &IBMCDC_TS

TEMPORARY TABLESPACE TEMP

QUOTA UNLIMITED ON &IBMCDC_TS;

-- create user

-- CREATE user IBMCDC identified by "&1"

-- default tablespace IBMCDC temporary tablespace TEMP;

-- Grant basic roles

-- grant connect to IBMCDC;

-- grant resource to IBMCDC;

grant select_catalog_role to IBMCDC;

-- Equivalent of basic roles (MPG)

grant create session to IBMCDC;

grant CREATE TRIGGER to IBMCDC;

grant CREATE SEQUENCE to IBMCDC;

grant CREATE CLUSTER to IBMCDC;

grant CREATE TYPE to IBMCDC;

grant CREATE PROCEDURE to IBMCDC;

grant CREATE TABLE to IBMCDC;

grant CREATE INDEXTYPE to IBMCDC;

grant CREATE OPERATOR to IBMCDC;

grant unlimited tablespace to ibmcdc; # Mandatory (apparently)

-- Table DDL permissions

grant create any table to IBMCDC;

grant alter any table to IBMCDC;

grant drop any table to IBMCDC;

grant lock any table to IBMCDC;

-- Table DML permissions

grant select any table to IBMCDC;

grant flashback any table to IBMCDC;

grant insert any table to IBMCDC;

grant update any table to IBMCDC;

grant delete any table to IBMCDC;

-- Index and view DDL permissions

grant create any index to IBMCDC;

grant alter any index to IBMCDC;

grant drop any index to IBMCDC;

grant create any view to IBMCDC;

grant drop any view to IBMCDC;

-- Trigger DDL and DML permissions (only required for CDC Trigger-based)

grant create any trigger to IBMCDC;

grant alter any trigger to IBMCDC;

grant drop any trigger to IBMCDC;

-- Sequence DDL and DML permissions

grant create any sequence to IBMCDC;

grant select any sequence to IBMCDC;

-- Procedure permissions

grant create any procedure to IBMCDC;

grant execute any procedure to IBMCDC;

grant execute on sys.dbms_flashback to IBMCDC;

-- Permission to perform select on the v_$ tables

grant select any dictionary to IBMCDC;

-- General system views

grant select on sys.v_$database to IBMCDC;

grant select on sys.v_$controlfile to IBMCDC;

grant select on sys.v_$version to IBMCDC;

grant select on sys.nls_database_parameters to IBMCDC;

-- Archive and redo logs

grant select on sys.v_$log to IBMCDC;

grant select on sys.v_$logfile to IBMCDC;

grant select on sys.v_$archived_log to IBMCDC;

grant select on sys.v_$log_history to IBMCDC;

-- Sessions and transactions

grant alter session to IBMCDC;

grant select on sys.v_$session to IBMCDC;

grant select on sys.v_$transaction to IBMCDC;

grant select on sys.v_$mystat to IBMCDC;

-- Tables, indexes, columns and related views

grant select on sys.all_coll_types to IBMCDC;

grant select on sys.all_type_attrs to IBMCDC;

grant select on sys.dba_tables to IBMCDC;

grant select on sys.dba_tab_comments to IBMCDC;

grant select on sys.dba_tab_columns to IBMCDC;

grant select on sys.dba_col_comments to IBMCDC;

grant select on sys.dba_indexes to IBMCDC;

grant select on sys.dba_ind_columns to IBMCDC;

grant select on sys.all_constraints to IBMCDC;

grant select on sys.dba_constraints to IBMCDC;

grant select on sys.all_cons_columns to IBMCDC;

grant select on sys.dba_cons_columns to IBMCDC;

grant select on sys.tab$ to IBMCDC;

grant select on sys.ind$ to IBMCDC;

grant select on sys.lob$ to IBMCDC;

grant select on sys.col$ to IBMCDC;

grant select on sys.icol$ to IBMCDC;

grant select on sys.coltype$ to IBMCDC;

grant select on sys.attrcol$ to IBMCDC;

grant select on sys.ccol$ to IBMCDC;

grant select on sys.cdef$ to IBMCDC;

-- Miscellaneous other objects

grant select on sys.obj$ to IBMCDC;

grant select on sys.dba_mviews to IBMCDC;

grant select on sys.dba_objects to IBMCDC;

grant select on sys.dba_sequences to IBMCDC;

grant select on sys.hist_head$ to IBMCDC;

grant select on sys.resource_cost to IBMCDC;

-- Storage

grant select on sys.dba_tablespaces to IBMCDC;

grant select on sys.dba_rollback_segs to IBMCDC;

-- Permissions

grant select on sys.dba_users to IBMCDC;

grant select on sys.dba_sys_privs to IBMCDC;

grant select on sys.dba_tab_privs to IBMCDC;

grant select on sys.dba_profiles to IBMCDC;

grant select on sys.dba_roles to IBMCDC;

grant select on sys.user$ to IBMCDC;

grant select on user_role_privs to IBMCDC;

exit;