SOL-C01 Question #36: Real Exam Question with Answer & Explanation

Question

You have a custom role named 'TRANSFORM ROLE that needs to load data into a table called 'ORDERS'. You want to ensure that this role can only load data into this specific table and has no other privileges. The table is located in database 'SALES DB' and schema 'PUBLIC'. Which of the following grants provides the LEAST PRIVILEGED access required for 'TRANSFORM ROLE' to perform the data load operation using COPY INTO command?

Options

• AGRANT INSERT, SELECT ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM
• BGRANT ALL PRIVILEGES ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM
• CGRANT INSERT ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM ROLE;
• DGRANT OWNERSHIP ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM ROLE;
• EGRANT INSERT ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM ROLE;

Explanation

The INSERT privilege is required to load data into the table. USAGE privilege on the database and schema is required to access the table. SELECT is not required for COPY INTO operations, only INSERT. OWNERSHIP grants complete control and is overly permissive. ALL PRIVILEGES also grants more privileges than needed.

No community discussion yet for this question.