This website uses cookies to ensure you get the best experience.
Learn more.
A payroll view is shared with analysts. They need its approved columns but must not access the raw payroll table. Which grant design best meets this requirement?
Published
- Transfer ownership of the raw table to the analyst group
- Grant SELECT on the raw table and hide it from the dashboard
- Grant required catalog/schema usage and SELECT on the governed view, without granting analysts SELECT on the raw table
- Grant BROWSE on the raw table instead of SELECT on the view
Comments — 0
Sign in to comment