

GRANT CREATE SESSION TO CSLR_MRAPTOR;

GRANT ALTER SESSION to CSLR_MRAPTOR ;
GRANT CREATE SESSION to CSLR_MRAPTOR ;
GRANT CONNECT to CSLR_MRAPTOR ;

revoke select any table from CSLR_MRAPTOR;
revoke select any dictionary from CSLR_MRAPTOR;

grant select on DBA_PDBS to CSLR_MRAPTOR ;

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

GRANT SELECT on dba_temp_free_space to CSLR_MRAPTOR ;
GRANT SELECT ON v_$asm_diskgroup to CSLR_MRAPTOR ;
grant select on gv_$resource_limit  to CSLR_MRAPTOR ;

grant select on tasy.APLICACAO_TASY to CSLR_MRAPTOR ;
grant select on tasy.PESSOA_FISICA_LOG_ACESSO to CSLR_MRAPTOR ;
grant select on tasy.CONSISTE_BASE_V to CSLR_MRAPTOR ;

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