0

I'd like to provide some user groups access to view Sensitivity Classifications. Currently it returns blank results in the reports tool, or directly querying sys.sensitivity_classifications table.

What's the minimum permission set, default or custom, which could be used to provide a read only view?

mcswiggen
  • 3
  • 1

1 Answers1

1

Based on

https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sensitivity-classifications-transact-sql?view=sql-server-ver16#permissions

Requires the VIEW ANY SENSITIVITY CLASSIFICATION permission.

SergeyA
  • 474
  • 3
  • 6
  • Thanks, didn’t see when searching before, perhaps not appearing in my SSMS as older version, will try granting directly, assume will work based on that info. – mcswiggen Jan 27 '24 at 16:54