GRANT SELECT ON "PUBLIC"."V$ARCHIVED_LOG"           TO "
cmid_user";
GRANT SELECT ON "PUBLIC"."V$DATABASE"               TO "
cmid_user";
GRANT SELECT ON "PUBLIC"."V$LOG"                    TO "
cmid_user";
GRANT SELECT ON "PUBLIC"."V$LOGFILE"                TO "
cmid_user";
GRANT SELECT ON "PUBLIC"."V$TRANSPORTABLE_PLATFORM" TO "
cmid_user";
GRANT SELECT ON "PUBLIC"."V$THREAD"                 TO "
cmid_user";
GRANT SELECT ON "PUBLIC"."V$DATABASE_INCARNATION"   TO "
cmid_user";

GRANT SELECT ON "SYS"."DBA_LOG_GROUPS"        TO "
cmid_user";
GRANT SELECT ON "SYS"."DBA_LOG_GROUP_COLUMNS" TO "
cmid_user";
GRANT SELECT ON "SYS"."DBA_TABLESPACES"       TO "
cmid_user";

GRANT SELECT ON "SYS"."OBJ$"          TO "
cmid_user";
GRANT SELECT ON "SYS"."TAB$"          TO "
cmid_user";
GRANT SELECT ON "SYS"."IND$"          TO "
cmid_user";
GRANT SELECT ON "SYS"."COL$"          TO "
cmid_user";

GRANT SELECT ON "SYS"."PARTOBJ$"      TO "
cmid_user";
GRANT SELECT ON "SYS"."TABPART$"      TO "
cmid_user";
GRANT SELECT ON "SYS"."TABCOMPART$"   TO "
cmid_user";
GRANT SELECT ON "SYS"."TABSUBPART$"   TO "
cmid_user";
COMMIT;

begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'DBA_USERS',
p_grantee => '
cmid_user',
p_privilege => 'SELECT',
p_grant_option => false);
end;
--
begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'ALL_TABLES',
p_grantee => '
cmid_user',
p_privilege => 'SELECT',
p_grant_option => false);
end;
--
begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'ALL_TAB_PARTITIONS',
p_grantee => '
cmid_user',
p_privilege => 'SELECT',
p_grant_option => false);
end;
--
begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'V_$PARAMETER',
p_grantee => '
cmid_user',
p_privilege => 'SELECT');
end;
--
begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'V_$SPPARAMETER',
p_grantee => '
cmid_user',
p_privilege => 'SELECT');
end;
--
begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'V_$STANDBY_LOG',
p_grantee => '
cmid_user',
p_privilege => 'SELECT');
end;
--
begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'V_$VERSION',
p_grantee => '
cmid_user',
p_privilege => 'SELECT');
end;
--
begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'INDPART$',
p_grantee => '
cmid_user',
p_privilege => 'SELECT');
end;
--
end;

GRANT READ ON DIRECTORY ONLINELOG_DIR to "
cmid_user";
GRANT READ ON DIRECTORY ARCHIVELOG_DIR to "
cmid_user";