Câu 4: SnowPro Advanced Administrator ADA-C02

The following commands were executed:Grant usage on database PROD to role PROD_ANALYST;Grant usage on database PROD to role PROD_SUPERVISOR;Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_ANALYST;Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_SUPERVISOR;Grant role PROD_ANALYST to user A;Grant role PROD_SUPERVISOR to user B;What authority does each user have on the WORKING schema?

1. A. Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.
2. B. Tables created by either user A or user B will be visible to both users.
3. C. All existing tables in schema PROD.WORKING will be visible to both users.
4. D. Both user A and user B can create tables in the PROD.WORKING schema. — đáp án hiện tại