Privileges to Manage Preexisting Objects
Below is the list of privileges required to manage Snowflake objects that did exist in the account and cannot be created from scratch.
Note
- All required parameters of a Snowflake Object can only be modified by role with
OWNERSHIPgrant on the object. - All Snowflake Objects can only be destroyed by role with
OWNERSHIPgrant on the object.
Database¶
To modify a database the MODIFY privilege will be required.
Warehouse¶
To modify a warehouse the MODIFY privilege will be required.
Resource monitor¶
To modify the Resource Monitor the MODIFY privilege will be required.
User¶
Role¶
Schema¶
To modify the schema the MODIFY and USAGE privileges will be required.
GRANT USAGE ON SCHEMA <database-name>.<schema-name> TO ROLE DATAOPS_ADMIN;
GRANT MODIFY ON SCHEMA <database-name>.<schema-name> TO ROLE DATAOPS_ADMIN;
Masking policy¶
Pipe¶
To modify a pipe the OPERATE privilege will be required. Note: only Optional Parameters can be modified using OPERATE.
GRANT OPERATE on PIPE <pipe-name> to ROLE DATAOPS_ADMIN ;
GRANT OWNERSHIP on MASKING POLICY <masking_policy_name> to role DATAOPS_ADMIN;
View¶
File format¶
Table¶
Stage¶
Stream¶
External table¶
Task¶
The OPERATE privilege allows updating status like resuming or suspending the task.