New answers tagged

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
0 votes

DDL_admin vs db_owner permissions

DBO access for a given database does NOT grant the ability to drop that given database. I've tested it. You should too.
MaximGhost's user avatar
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
-5 votes

list of users, logins ,permissions,account active ,last login date for SQL Server

Yes. Look at views in master database.
White Owl's user avatar
  • 727
0 votes

How to list all grants per user/role on PostgreSQL

For a quick check with psql just use: \df+ schema.procedure As usual you can use wildcards.
Antonio Bardazzi's user avatar
0 votes

How can I list all privileges that a PostgreSQL role has?

Here is m option to get privileges. Hope someone will find it useful WITH server_permissions AS ( SELECT r.rolname, 'Server_Permissions' AS "Level", r.rolsuper,...
George K's user avatar
  • 2,261
0 votes

SQL Account cannot access file system

The bulk insert is not able to access the file location, same with sys.dm_os_file_exists. So the general problem is the access to the file/directory. The access to the directory is going to be based ...
J.D.'s user avatar
  • 37.1k
0 votes

How to COPY table privileges dba_sys_privs into different table in Oracle

There is no built-in privilege copy utility, but it's easy enough to make your own with some simple scripting. Simply build your own DDL by querying the three main privilege views. You can then add ...
Paul W's user avatar
  • 578
0 votes

SQL Account cannot access file system

Instead of Master.dbo.xp_fileexist try SELECT * FROM sys.dm_os_file_exists('\SRV1\Statistic\Statistic_2024.csv'); Sign the stored procedure with sysadmins's certificate https://www.sommarskog.se/...
SergeyA's user avatar
  • 433
1 vote
Accepted

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

Top 50 recent answers are included