I have more than 10+ views in my database(i.e. myDb) in snowflake with the role analyst.
Now, I have created a new role i.e. developer and I want to give
grant select on view <> to role developer
permission to one particle view(i.e test_view).
How can I grant access to one particular view in snowflake?
Note: consider the schema name public
>Solution :
You do it almost exactly how you have guessed. VIEWs are schemaObjectPrivileges
CREATE ROLE developer;
CREATE VIEW test.test.test_view AS SELECT 1 AS id;
GRANT SELECT ON VIEW test.test.test_view TO ROLE developer;
SHOW GRANTS TO ROLE developer;