Guidance on Granting Permissions to an ETL User

Hi,

I am looking for advice on granting the appropriate permissions to an ETL user who is a client. As a DBA, I must ensure their access is sufficient for their tasks while maintaining security and compliance.

Specifically, I am considering granting the following permissions:

• GRANT SELECT ON DBA_EXTENTS;
• GRANT SELECT ON DBA_TABLESPACES;
• GRANT SELECT ON DBA_SEGMENTS;
• GRANT SELECT ON SYS.V_$DATABASE;
• GRANT LOGMINING;
• GRANT SELECT ON DBA_FREE_SPACE;
• GRANT SELECT ON SYS.V_$LOG;
• GRANT SELECT ON SYS.V_$TEMPFILE;
• GRANT SELECT ON SYS.V_$DATAFILE;

Questions:

1. Are there specific security concerns or risks associated with granting these permissions to an external user?