This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
To successfully run SELECT * FROM corpdata.finance.sales, which minimum set of privileges must a user have?
SELECT * FROM corpdata.finance.sales
SELECT on the table only; higher-level privileges are implicit.
SELECT
USE CATALOG on corpdata, USE SCHEMA on finance, and SELECT on the table.
USE CATALOG
corpdata
USE SCHEMA
finance
ALL PRIVILEGES on the catalog only.
ALL PRIVILEGES
Where are final row- and column-level filters enforced in the Unity Catalog query lifecycle?
Inside Unity Catalog before any storage access occurs.
In the cloud storage service when objects are read.
On the compute (cluster or SQL warehouse) after data is returned from storage.
A schema contains hundreds of tables that a reporting group must read now and in the future. Which grant pattern best balances least privilege with low maintenance?
GRANT SELECT on the schema plus USE CATALOG and USE SCHEMA.
GRANT SELECT
GRANT SELECT individually on every existing and new table as they appear.
GRANT ALL PRIVILEGES at the catalog level.
GRANT ALL PRIVILEGES
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?