The following commands have been run:
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?
Which steps are needed to configure OKTAAPI token integration in Snowflake?
Community Discussion
Which command can temporarily disable multi-factor authentication (MFA) for the Snowflake username user1 for 24 hours?
Community Discussion
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the accountant role.
An application using the accountant role must use this warehouse to run financial reports and track the compute credits consumed by the warehouse. What minimum warehouse privileges should be granted to the role to satisfy these requirements?
Community Discussion
A user has enrolled in multi-factor authentication (MFA) to connect to Snowflake. The user tells the Snowflake Administrator that they lost their mobile phone the prior evening.
Which action should the Administrator take to enable the user to sign in to the system without revoking the user’s MFA enrollment?
Community Discussion