Question : In the documentation for ADD SIGNATURE, they have the following caveat: Module signing should only be used to […]
Tag: signature
SSDT Schema Comparison for Stored Procedure signed by a Certificate
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
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
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
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
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
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
Question : Assume that there is a certificate created in database create certificate certName with subject = ‘subj’; GO And […]