Which type of role can be granted to a share?
Which type of role can be granted to a share?
The correct answer is 'Database role'. In the context of database management systems such as Snowflake, roles that can be granted to a share include database roles. This allows for controlled access to database objects like tables, schemas, and other resources. Granting database roles to shares ensures that specified permissions are applied to the objects within the scope of that role.
Grant the database role to a share and grant future privileges on an object to the database role: GRANT DATABASE ROLE dbr1 TO SHARE myshare; GRANT SELECT ON FUTURE TABLES IN SCHEMA sh TO DATABASE ROLE dbr1;
https://docs.snowflake.com/en/sql-reference/sql/grant-database-role-share