May 2018
Intermediate to advanced
576 pages
30h 25m
English
Using this syntax, we can grant or revoke privileges on all objects of a certain kind in a specific schema:
GRANT SELECT ON ALL TABLES IN SCHEMA staging TO bob;
You still need to grant the privileges on the schema itself in a separate GRANT statement.