GRANT SELECT ON "PUBLIC".V$DATABASE TO cmid_user; GRANT SELECT ON "PUBLIC".V$CONTAINERS TO cmid_user;
GRANT SELECT ON DBA_USERS TO cmid_user; GRANT SELECT ON DBA_TABLES TO cmid_user; GRANT SELECT ON DBA_OBJECT_TABLES TO cmid_user; GRANT SELECT ON DBA_INDEXES TO cmid_user; GRANT SELECT ON DBA_OBJECTS TO cmid_user; GRANT SELECT ON DBA_VIEWS TO cmid_user;
GRANT CREATE TABLE <schema.table> TO cmid_user; <--Unless you grant on ANY TABLE GRANT SELECT ON ALL_CONSTRAINTS TO cmid_user; GRANT SELECT ON ALL_OBJECTS TO cmid_user;
GRANT SELECT ON SYS.TAB$ TO cmid_user; GRANT SELECT ON SYS.RECYCLEBIN$ TO cmid_user; GRANT SELECT ON SYS.COL$ TO cmid_user; <-- If cmid_user is the owner of the target schema GRANT SELECT ON SYS.CCOL$ TO <cmid_user>; GRANT SELECT ON SYS.CDEF$ TO cmid_user; GRANT SELECT ON SYS.OBJ$ TO cmid_user; GRANT SELECT ON SYS.COLTYPE$ TO cmid_user; GRANT SELECT ON SYS.ATTRCOL$ TO cmid_user; GRANT SELECT ON SYS.IDNSEQ$ TO cmid_user; GRANT SELECT ON SYS.ATTRCOL$ TO cmid_user; GRANT SELECT ON SYS.IDNSEQ$ TO cmid_user; GRANT SELECT ON SYS.IND$ TO cmid_user;
-- Grant the following if cmid_user is NOT the owner of the target schema. If you prefer, you -- can grant to individual target tables and indexes instead of to ANY TABLE or ANY INDEX. GRANT ALTER SESSION TO cmid_user; GRANT RESOURCE TO cmid_user; GRANT SELECT ANY TABLE TO cmid_user; GRANT SELECT ANY DICTIONARY TO <cmid_user>; GRANT ALTER ANY TABLE TO cmid_user; GRANT CREATE ANY TABLE TO cmid_user; GRANT DROP ANY TABLE TO cmid_user; GRANT INSERT ANY TABLE TO cmid_user; GRANT UPDATE ANY TABLE TO cmid_user; GRANT DELETE ANY TABLE TO cmid_user; GRANT CREATE ANY INDEX TO cmid_user; GRANT ALTER ANY INDEX TO cmid_user; GRANT DROP ANY INDEX TO cmid_user;
•Amazon RDS for Oracleターゲットの場合、RDSにマスタユーザーとしてログインし、Oracleターゲットに接続するデータベース取り込みとレプリケーションユーザー(cmid_user)に次のユーザー特権を付与します。
GRANT CREATE SESSION TO cmid_user;
GRANT SELECT on "PUBLIC".V$DATABASE TO cmid_user;
GRANT SELECT on DBA_USERS TO cmid_user; GRANT SELECT on DBA_TABLES TO cmid_user; GRANT SELECT on DBA_INDEXES TO cmid_user; GRANT SELECT ON DBA_VIEWS TO cmid_user;
GRANT CREATE TABLE <schema.table> TO cmid_user; GRANT SELECT on SYS.TAB$ TO cmid_user; GRANT SELECT on SYS.COL$ TO cmid_user; GRANT SELECT on SYS.OBJ$ TO cmid_user; GRANT SELECT on SYS.IND$ TO cmid_user;
-- Grant the following if cmid_user is NOT the owner of the target schema. If you prefer, you -- can grant to individual target tables and indexes instead of to ANY TABLE or INDEX. GRANT ALTER SESSION TO cmid_user; GRANT RESOURCE TO cmid_user; GRANT SELECT ANY TABLE TO cmid_user; GRANT SELECT ANY DICTIONARY TO <cmid_user>; GRANT ALTER ANY TABLE TO cmid_user; GRANT CREATE ANY TABLE TO cmid_user; GRANT DROP ANY TABLE TO cmid_user; GRANT INSERT ANY TABLE TO cmid_user; GRANT UPDATE ANY TABLE TO cmid_user; GRANT DELETE ANY TABLE TO cmid_user; GRANT CREATE ANY INDEX TO cmid_user; GRANT ALTER ANY INDEX TO cmid_user; GRANT DROP ANY INDEX TO cmid_user;