Reviewed by Aditya Kumar · Last reviewed 2026-03-24
GRANT SELECT ON view_name TO role_or_user; Same as table. **Key**: View grants don't grant underlying table accessâuser needs privileges on base tables unless view is security definer. **Snowflake**: Secure views can restrict underlying data. **Roles**: Grant to role, assign...
GRANT SELECT ON view_name TO role_or_user; Same as table. Key: View grants don't grant underlying table accessâuser needs privileges on base tables unless view is security definer. Snowflake: Secure views can restrict underlying data. Roles: Grant to role, assign role to users. Audit: Track who has access; least privilege.
Red Flag: Granting view without base tableâquery fails. Pro-Move: 'We use RBAC: grant view to analyst role; base tables only to ETL roleâseparation of concerns, audited quarterly.'
According to DataEngPrep.tech, this is one of the most frequently asked SQL interview questions, reported at 1 company. DataEngPrep.tech maintains an editor-reviewed database of 1,863 data engineering interview questions across 7 categories.