QuestionQ60
Manage and administer Snowflake accounts, data security, and governanceA development team has created a new schema for a new project. The developers hold the DEV_TEAM role, which was configured with these statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV_TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member's access is configured with the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN_NAME = ’JDOE’ DEFAULT_ROLE=’JDOE PROFILE’;
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any developer cannot be accessed by the team as a whole. How can an Administrator resolve this issue?
Community Discussion