Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: signature

Why can I not DENY permissions through module signing?

By adminPosted on September 19, 2022

Question : In the documentation for ADD SIGNATURE, they have the following caveat: Module signing should only be used to […]

SSDT Schema Comparison for Stored Procedure signed by a Certificate

By adminPosted on May 10, 2022

Question : I am using SSDT 14.0.50730.0 in Visual Studio Professional 2015. I am comparing databases between two instances and […]

Find signed procedures, functions, triggers, assemblies and by which certificates / asymmetric keys

By adminPosted on March 25, 2022

Question : I have created a few Certificates (via CREATE CERTIFICATE) and Asymmetric Keys (via CREATE ASYMMETRIC KEY) and used […]

Impersonate user or login mapped to certificate

By adminPosted on February 11, 2022

Question : Assume that there is a certificate created in database create certificate certName with subject = ‘subj’; GO And […]

SQL Server Impersonation is just NOT working

By adminPosted on March 8, 2021

Question : I simply would like a very limited user, in its own database, to call an update procedure on […]

Grant execute on xp_logevent to sa using sa user to do it

By adminPosted on February 19, 2021

Question : Running a SQL Server 2012 CLR stored procedure with this code: const string executeLog = “EXEC master..xp_logevent @errorNumber, […]

SQL Server Impersonation is just NOT working

By adminPosted on October 12, 2020

Question : I simply would like a very limited user, in its own database, to call an update procedure on […]

Impersonate user or login mapped to certificate

By adminPosted on July 9, 2020

Question : Assume that there is a certificate created in database create certificate certName with subject = ‘subj’; GO And […]

Recent Posts

  • Table design for efficiently retrieving “most recent row” per FK’d item whose PK is a GUID
  • Why does my BETWEEN predicate not match any rows? [closed]
  • MySQL using a index referencing a different column
  • mysql – Recovering databases from ibdata1 , .frm and .idb
  • Postgres: What could cause the error “cannot call populate_composite on a scalar”?
  • Safely changing innodb_buffer_pool_size on MySQL replication master?
  • Why my index don’t update?
  • MySQL – What exactly does smallint(2) permit? [duplicate]
  • Optimize a slow nested loops join
  • How to perform query operation on another query result
  • Identity column re-seed: when it is necessary?
  • MySQL -> Loop through a table, running a stored procedure on each entry
  • Optimize Postgresql query
  • How to speed up mysql query?
  • How to optimize a query for < operator
  • SQL Server transaction log [duplicate]
  • Can’t do a full backup because the log is full [duplicate]
  • Mysql error : Slave SQL Could not execute …on table
  • mySQL changing output unit of ST_Distance function
  • Is it bad to have a cyclical relationship?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding