How can i grant select on all future views in a schema or database Even with all privileges command, you have to grant one usage privilege against the object to be effective. This works fine but i want the role to have access to all future views too
chonera - YouTube
Grant select on view <schema>.<view> to r.
In snowflake, you can grant select privileges on a specific table to another user or role using the **`grant`** statement
This statement allows you to define the specific privileges you want to grant to a user or role for a particular table. This article provides a process in which access to specific views in the account_usage schema of the snowflake database can be granted to custom roles. The view being added can reference other objects (tables, views, functions etc) from other databases All the databases referenced (all levels) must be added to the datashare using reference_usage grants.
Learn snowflake user and role management best practices Set up rbac, managed schemas, and future grants for secure, scalable access control in 2025. Granting a role to a user enables the user to perform all operations allowed by the role (through the access privileges granted to the role). Snowflake runs tasks with the privileges of the task owner (i.e
The role that has ownership privilege on the task) so when a task is running a select statement it will run that as the role that owns the task
So that role must have select privs on the objects it is selecting from. Unfortunately in snowflake, there is no as such command to grant all access via a single command
