3 votes

In Postgres, can an isolation level be set as mandatory?

No, all you can do is set the default_transaction_isolation parameter to serializable and hope that nobody explicitly selects a different isolation level.
Laurenz Albe's user avatar
  • 50.2k
1 vote

Module signing on a trigger which accesses system views. Base table is on a custom schema

First of all, when I reproduce using your code - I have a different message: Msg 300, Level 14, State 1, Procedure AuditINSERT, Line 9 [Batch Start Line 0] VIEW SERVER PERFORMANCE STATE permission ...
Zikato's user avatar
  • 4,403
1 vote

MS SQL - Minimum Permissions to View Sensitivity Classifications

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 ...
SergeyA's user avatar
  • 433

Only top scored, non community-wiki answers of a minimum length are eligible