CREATE USER C##CSLR_MRAPTOR IDENTIFIED BY "abc123..." DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;

GRANT CREATE SESSION TO C##CSLR_MRAPTOR CONTAINER=ALL;
ALTER USER C##CSLR_MRAPTOR set container_data=all container=current;

GRANT ALTER SESSION to C##CSLR_MRAPTOR container=all;
GRANT CREATE SESSION to C##CSLR_MRAPTOR container=all;
GRANT CONNECT to C##CSLR_MRAPTOR container=all;
ALTER USER C##CSLR_MRAPTOR DEFAULT ROLE ALL;
revoke select any table from C##CSLR_MRAPTOR;
revoke select any dictionary from C##CSLR_MRAPTOR;

grant select on DBA_PDBS to C##CSLR_MRAPTOR container=all;

Grant select on dba_tab_privs to C##CSLR_MRAPTOR container=all;
grant select on tasy.APLICACAO_TASY to C##CSLR_MRAPTOR container=all;
grant select on tasy.PESSOA_FISICA_LOG_ACESSO to C##CSLR_MRAPTOR container=all;
grant select on tasy.CONSISTE_BASE_V to C##CSLR_MRAPTOR container=all;
grant select on V_$ARCHIVED_LOG to C##CSLR_MRAPTOR container=all;
grant select on V_$LOG_HISTORY to C##CSLR_MRAPTOR container=all;
grant select on V_$ASM_DISK to C##CSLR_MRAPTOR container=all;
grant select on V_$ASM_DISKGROUP  to C##CSLR_MRAPTOR container=all;
grant select on DBA_AUDIT_SESSION to C##CSLR_MRAPTOR container=all;
grant select on DBA_SYS_PRIVS to C##CSLR_MRAPTOR container=all;
grant select on ALL_TAB_PRIVS to C##CSLR_MRAPTOR container=all;
grant select on CSLR.DATAPUMP_LOG to C##CSLR_MRAPTOR container=all;
grant select on DBA_ROLE_PRIVS to C##CSLR_MRAPTOR container=all;
grant select on V_$LOCK to C##CSLR_MRAPTOR container=all;
grant select on V_$LOCKED_OBJECT to C##CSLR_MRAPTOR container=all;
grant select on CSLR.CSLR_MIRROR to C##CSLR_MRAPTOR container=all;
grant select on V_$LATCH to C##CSLR_MRAPTOR container=all;
grant select on REGISTRY$HISTORY to C##CSLR_MRAPTOR container=all;
grant select on V_$PGASTAT to C##CSLR_MRAPTOR container=all;
grant select on V_$LIBRARYCACHE to C##CSLR_MRAPTOR container=all;
grant select on V_$PROCESS to C##CSLR_MRAPTOR container=all;
grant select on gV_$RESOURCE_LIMIT  to C##CSLR_MRAPTOR container=all;
grant select on V_$LOGFILE to C##CSLR_MRAPTOR container=all;
grant select on V_$LOG to C##CSLR_MRAPTOR container=all;
grant select on V_$BACKUP_ARCHIVELOG_SUMMARY to C##CSLR_MRAPTOR container=all;
grant select on V_$BACKUP_CONTROLFILE_SUMMARY to C##CSLR_MRAPTOR container=all;
grant select on V_$BACKUP_DATAFILE_SUMMARY to C##CSLR_MRAPTOR container=all;
grant select on DBA_TAB_STATISTICS to C##CSLR_MRAPTOR container=all;
grant select on V_$SYSSTAT to C##CSLR_MRAPTOR container=all;
grant select on V_$SGASTAT to C##CSLR_MRAPTOR container=all;
grant select on DBA_FREE_SPACE to C##CSLR_MRAPTOR container=all;
grant select on DBA_TEMP_FREE_SPACE to C##CSLR_MRAPTOR container=all;
grant select on DBA_DATA_FILES to C##CSLR_MRAPTOR container=all;
grant select on DBA_JOBS to C##CSLR_MRAPTOR container=all;
grant select on DBA_INDEXES to C##CSLR_MRAPTOR container=all;
grant select on DBA_OBJECTS to C##CSLR_MRAPTOR container=all;
grant select on GV_$SESSION to C##CSLR_MRAPTOR container=all;
grant select on V_$SESSION to C##CSLR_MRAPTOR container=all;
grant select on DBA_TABLES to C##CSLR_MRAPTOR container=all;
grant select on DBA_USERS to C##CSLR_MRAPTOR container=all;
grant select on DBA_TABLESPACES to C##CSLR_MRAPTOR container=all;
grant select on V_$TABLESPACE to C##CSLR_MRAPTOR container=all;
grant select on V_$DATAFILE to C##CSLR_MRAPTOR container=all;
grant select on V_$PARAMETER to C##CSLR_MRAPTOR container=all;
grant select on V_$SESSION to C##CSLR_MRAPTOR container=all;
grant select on V_$UNDOSTAT to C##CSLR_MRAPTOR container=all;
grant select on V_$INSTANCE to C##CSLR_MRAPTOR container=all;
grant select on V_$SYSTEM_EVENT to C##CSLR_MRAPTOR container=all;
grant select on DBA_UNDO_EXTENTS to C##CSLR_MRAPTOR container=all;
grant select on  dba_data_files to C##CSLR_MRAPTOR container=all;
grant select on  dba_temp_files  to C##CSLR_MRAPTOR container=all;
grant select on  V_$TEMP_SPACE_HEADER  to C##CSLR_MRAPTOR container=all;

GRANT SELECT on dba_temp_free_space to C##CSLR_MRAPTOR container=all;
GRANT SELECT ON v_$asm_diskgroup to C##CSLR_MRAPTOR container=all;
grant select on gv_$resource_limit  to C##CSLR_MRAPTOR container=all;

grant select on tasy.APLICACAO_TASY to C##CSLR_MRAPTOR container=all;
grant select on tasy.PESSOA_FISICA_LOG_ACESSO to C##CSLR_MRAPTOR container=all;
grant select on tasy.CONSISTE_BASE_V to C##CSLR_MRAPTOR container=all;

exec dbms_network_acl_admin.create_acl(acl => 'resolve.xml',description => 'resolve acl', principal =>'C##CSLR_MRAPTOR', is_grant => true, privilege => 'resolve'); 
exec dbms_network_acl_admin.assign_acl(acl => 'resolve.xml', host =>'*');
