Mass Ingestion
- Mass Ingestion
- 所有产品
GRANT CREATE SESSION TOcmid_user; GRANT SELECT ON "PUBLIC".V$DATABASE TOcmid_user; GRANT SELECT ON "PUBLIC".V$CONTAINERS TOcmid_user; GRANT SELECT ON DBA_USERS TOcmid_user; GRANT SELECT ON DBA_TABLES TOcmid_user; GRANT SELECT ON DBA_OBJECT_TABLES TOcmid_user; GRANT SELECT ON DBA_INDEXES TOcmid_user; GRANT SELECT ON DBA_OBJECTS TOcmid_user; GRANT CREATE TABLE <schema.table> TOcmid_user; <--Unless you grant on ANY TABLE GRANT SELECT ON ALL_CONSTRAINTS TOcmid_user; GRANT SELECT ON ALL_OBJECTS TOcmid_user; GRANT SELECT ON SYS.TAB$ TOcmid_user; GRANT SELECT ON SYS.RECYCLEBIN$ TOcmid_user; GRANT SELECT ON SYS.COL$ TOcmid_user; <-- If cmid_user is the owner of the target schema GRANT SELECT ON SYS.CCOL$ TO <cmid_user>; GRANT SELECT ON SYS.CDEF$ TOcmid_user; GRANT SELECT ON SYS.OBJ$ TOcmid_user; GRANT SELECT ON SYS.COLTYPE$ TOcmid_user; GRANT SELECT ON SYS.ATTRCOL$ TOcmid_user; GRANT SELECT ON SYS.IDNSEQ$ TOcmid_user; GRANT SELECT ON SYS.ATTRCOL$ TOcmid_user; GRANT SELECT ON SYS.IDNSEQ$ TOcmid_user; GRANT SELECT ON SYS.IND$ TOcmid_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 TOcmid_user; GRANT RESOURCE TOcmid_user; GRANT SELECT ANY TABLE TOcmid_user; GRANT SELECT ANY DICTIONARY TO <cmid_user>; GRANT ALTER ANY TABLE TOcmid_user; GRANT CREATE ANY TABLE TOcmid_user; GRANT DROP ANY TABLE TOcmid_user; GRANT INSERT ANY TABLE TOcmid_user; GRANT UPDATE ANY TABLE TOcmid_user; GRANT DELETE ANY TABLE TOcmid_user; GRANT CREATE ANY INDEX TOcmid_user; GRANT ALTER ANY INDEX TOcmid_user; GRANT DROP ANY INDEX TOcmid_user;
GRANT CREATE SESSION TOcmid_user; GRANT SELECT on "PUBLIC".V$DATABASE TOcmid_user; GRANT SELECT on DBA_USERS TOcmid_user; GRANT SELECT on DBA_TABLES TOcmid_user; GRANT SELECT on DBA_INDEXES TOcmid_user; GRANT CREATE TABLE <schema.table> TOcmid_user; GRANT SELECT on SYS.TAB$ TOcmid_user; GRANT SELECT on SYS.COL$ TOcmid_user; GRANT SELECT on SYS.OBJ$ TOcmid_user; GRANT SELECT on SYS.IND$ TOcmid_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;
begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'V_$CONTAINERS', p_grantee => 'cmid_user', p_privilege => 'SELECT'); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'DBA_OBJECT_TABLES', p_grantee => 'cmid_user', p_privilege => 'SELECT'); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'DBA_OBJECTS', p_grantee => 'cmid_user', p_privilege => 'SELECT'); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'ALL_CONSTRAINTS', p_grantee => 'cmid_user', p_privilege => 'SELECT'); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'ALL_OBJECTS', p_grantee => 'cmid_user', p_privilege => 'SELECT'); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'RECYCLEBIN$', p_grantee => 'cmid_user', p_privilege => 'SELECT'); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'CCOL$', p_grantee => 'cmid_user', p_privilege => 'SELECT', p_grant_option => false); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'CDEF$', p_grantee => 'cmid_user', p_privilege => 'SELECT', p_grant_option => false); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'COLTYPE$', p_grantee => 'cmid_user', p_privilege => 'SELECT', p_grant_option => false); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'ATTRCOL$', p_grantee => 'cmid_user', p_privilege => 'SELECT', p_grant_option => false); end; / begin rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'IDNSEQ$', p_grantee => 'cmid_user', p_privilege => 'SELECT', p_grant_option => false); end; /