snowflake-cloud-data-platformsnowflake-schema

Snowflake - Would it be possible to drop, modify, replace the same table from two different roles?


There is a table created by a Sysadmin. I would like both Sysadmin and Analyst role to be able to drop, modify, or replace the same table if possible. I understand we can change ownership of the table, but if both roles can drop, modify, or replace the table, that would be great.

This ANALYST role has limited access to snowflake databases and has following grant privileges:


Solution

  • Regarding Ownership: You are right, only one role can be the owner of an object at one particular point in time.

    However, you can have several roles, which are able to DROP, MODIFY and REPLACE the same table. This can be achieved by either