Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including
Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Questions tagged [signature]
A means of conveying the authenticity of a message, file, or code module. A public and private key pair (sometimes placed into a certificate) is used in this process. The private key is used to generate the signature / sign the content. The public key is then used to verify the content against the signature. In Microsoft SQL Server, signatures can be added to stored procedures, functions, triggers, and assemblies.
I want to sign plaintext using a SQL Server certificate and then verify that signature using the certificate's public key on an external system. Here's what I've tried.
-- Create a self-signed ...
Jun 4, 2021 at 23:23
Inside a user database, I have two certificates, both are used for signing stored procedures
First cert was created long time ago by someone
Second I created myself for testing purposes
Feb 7, 2020 at 15:02
I'm trying to add "System.Messaging.dll" using the guidance provided by Solomon Rutzky in his post Assembly deployment with permission UNSAFE or EXTERNAL_ACCESS using asymmetric key but I'm failing at ...
Mar 18, 2019 at 9:54
So, given MS SQL 2008R2 or better:
I want to not only store data in a table but be able for my application to automatically verify it was not modified.
Solution seems to be to use SignByCert to ...
Nov 6, 2017 at 21:42
In the documentation for ADD SIGNATURE, they have the following caveat:
Module signing should only be used to grant permissions, never to deny or revoke permissions.
My question is: why? ...
Aug 7, 2017 at 2:10
I have a procedure TheNotificationProcedure that makes a cross-database call to msdb.dbo.sp_send_dbmail.
It gets invoked (indirectly) from a service broker queue:
CREATE QUEUE [Blah].[TheQueue]
Mar 2, 2017 at 22:47
I use cross database certificates (as explained by Erland Sommarskog) to control access to a certain database in my environment ( SQL Server 2008 R2 ).
I have stored procedures in database A that ...
Jan 13, 2017 at 22:39
I simply would like a very limited user, in its own database, to call an update procedure on our database to tell us that it has updated a table, which it has access to.
I have allowed the user ...
Nov 10, 2016 at 18:28
Assume that there is a certificate created in database
create certificate certName
with subject = 'subj';
And a user mapped to this certificate
create user userName
from certificate ...
Oct 25, 2016 at 12:11
I have a situation that, while I was able to work around it (as the repro will show), I don't understand. Here are the high points
Two databases, ChainingSource and ChainDestination, both of which ...
Oct 20, 2016 at 23:32
I have a certificate I would like to remove from the database.
If I issue the command
DROP CERTIFICATE <FooCert>
I get the error
The certificate cannot be dropped because one or more entities ...
Jun 7, 2016 at 19:35
I have created a few Certificates (via CREATE CERTIFICATE) and Asymmetric Keys (via CREATE ASYMMETRIC KEY) and used them to sign and counter-sign various Stored Procedures, User-Defined Functions (...
Jan 22, 2016 at 19:48
I am using SSDT 14.0.50730.0 in Visual Studio Professional 2015. I am comparing databases between two instances and it is finding that there are stored procedures that do not match with regard to ...
Dec 7, 2015 at 22:12
I have a Microsoft SQL Server 2014. The mail system is configured via DBMail and
there is one stored proc in main web app (having its own database) which executes msdb's sysmail_update_account_sp by ...
Nov 9, 2015 at 15:26
I have a two users, user1 and user2.
User1 has sysadmin rights and I have created a database level trigger through sa.
Now I am trying to create a table through user2 who has db-ddladmin rights and ...
Nov 9, 2015 at 11:06
I have a certificate I am using for inter-DB access to a stored procedure in SQL Server, and am able to provide access to the stored procedure by creating a new user in the database using:
Oct 27, 2015 at 12:57
Running a SQL Server 2012 CLR stored procedure with this code:
const string executeLog = "EXEC master..xp_logevent @errorNumber, @message, informational";
using (SqlCommand cmd = new SqlCommand(...
Jun 30, 2015 at 10:58
We have the 2 databases.
There are some users who want to extract data from HR database. But we don't want to give direct access to that HR database.
So, we created the special views ...
Dec 17, 2014 at 16:02
I am trying to create a single (self signed) certificate and deploy across many databases and instances.
I create and backup the cert with:
CREATE CERTIFICATE DavesCert ...
Jul 25, 2012 at 0:20
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our
Accept all cookies
Necessary cookies only