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. Here’s the SQL syntax to grant SELECT privileges:
GRANT SELECT ON TABLE table_name TO [USER | ROLE] grantee_name;
– **`table_name`**: The name of the table for which you want to grant SELECT privileges.
– **`USER | ROLE`**: Specify whether you are granting the privileges to a user or a role.
– **`grantee_name`**: The name of the user or role to whom you are granting the privileges.
Here’s an example of granting SELECT privileges on a table named **`Sales`** to a user named **`analyst_user`**:
GRANT SELECT ON TABLE Sales TO USER analyst_user;
You can also grant privileges to a role. For example, to grant SELECT privileges on the same table to a role named **`data_viewer`**, you would use:
GRANT SELECT ON TABLE Sales TO ROLE data_viewer;
It’s important to note that Snowflake follows a principle of least privilege, meaning that users and roles have no privileges on objects by default. You need to explicitly grant the necessary privileges to allow access.
Remember to replace **`Sales`**, **`analyst_user`**, and **`data_viewer`** with the actual names of your table, user, and role. Additionally, you can grant other privileges like INSERT, UPDATE, DELETE, and more using similar **`GRANT`** statements, tailored to your access requirements.