sql / beginner
Snippet
Granting Read-Only Privileges with GRANT SELECT
The GRANT statement is used in SQL to provide database permissions to specific users or roles. Giving SELECT privileges allows a user to read table data without giving them permission to modify or delete existing records.
snippet.sql
sql
1
GRANT SELECT ON employees TO analyst_user;
Breakdown
1
GRANT SELECT ON employees TO analyst_user;
Authorizes the database user 'analyst_user' to execute SELECT queries on the 'employees' table.