Learn about the permissions that can be assigned to views in Firebolt, including controlling access to view data and managing view-level operations.
Privilege | Description | GRANT Syntax | REVOKE Syntax | |
---|---|---|---|---|
SELECT | Allows selecting data from a view. | GRANT SELECT ON VIEW <view_name> TO <role_name>; | REVOKE SELECT ON VIEW <view_name> FROM <role_name>; | |
MODIFY | Allows modifying and dropping a view. | GRANT MODIFY ON VIEW <view_name> TO <role_name>; | REVOKE MODIFY ON VIEW <view_name> FROM <role_name>; | |
ALL [PRIVLEGES] | Grants all privileges over the view to a role. | GRANT ALL ON VIEW <view_name> TO <role_name>; | REVOKE ALL ON VIEW <view_name> FROM <role_name>; | |
Views are created at the schema level. To grant privileges to create views, refer to the schema-level privileges documentation. |
read_role
permission to query data from the viewtest
view and ensure the view_owner
has the necessary permission to read data from the referenced_table
table, allowing the view to function correctly.
developer_role
permission to alter or drop the my_view
view:
developer_role
with all permissions over the my_view
view: