SQL GRANT SELECT ON VIEW

SQL GRANT SELECT ON VIEW is a SQL statement in the Views category. Views are commonly used to implement row-level and column-level security by granting access to views instead of base tables. The syntax is GRANT SELECT ON view_name TO role_name;. It returns grant executed. A close relative is CREATE VIEW, which creates a virtual table based on a SELECT query. Think of it as a saved query that acts like a table. A close relative is DROP VIEW, which removes a view from the database. Does not affect the underlying tables. A close relative is ALTER VIEW, which modifies an existing view definition. More about this category: Database views — CREATE VIEW, DROP VIEW, ALTER VIEW, materialized views. Related Views entries: CREATE VIEW, DROP VIEW, ALTER VIEW, MATERIALIZED VIEW, CREATE OR REPLACE VIEW, WITH CHECK OPTION, INDEXED VIEW (WITH SCHEMABINDING), View WITH ENCRYPTION.