Learn about location-related permissions in Firebolt.
Privilege | Description | GRANT Syntax | REVOKE Syntax |
---|---|---|---|
MODIFY | Grants the ability to modify location objects owned by the role. | GRANT MODIFY ON LOCATION <location_name> TO <role>; | REVOKE MODIFY ON LOCATION <location_name> FROM <role>; |
USAGE | Grants the ability to use location objects without seeing credentials. | GRANT USAGE ON LOCATION <location_name> TO <role>; | REVOKE USAGE ON LOCATION <location_name> FROM <role>; |
my_role
permission to modify the loc
location:
my_role
permission to use the loc
location: