Grant a DBA Role, all the required privileges across schemas without granting sysadmin or account admin access in Snowflake?
Is there a way to grant development privileges to one role (Role_Dev) in a snowflake database with which a user can perform development activities such as,
- ddl (create/alter/drop tables/views/stored procedures),
- dml (insert/update/delete rows in tables) activities,
- create modify stages/functions/sequences,
- running stored procedures/functions across schemas where each schema can have a different owner an they might created.
The purpose of this role is to avoid granting sys admin/account admin role to a user to support the development activities. Please little 'r' me if anyone has done something like this before or have an idea?
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds