Is it possible to add a certificate to a database role?

6 votes

1 answer

940 views

                          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:

    CREATE CERTIFICATE testCertificate
    FROM FILE = 'test_certificate6.cer';

    CREATE USER testCertificateUser 
    FROM CERTIFICATE testCertificate;

    GRANT AUTHENTICATE TO testCertificateUser;
    GRANT EXECUTE ON storedProc1 TO testCertificateUser;

but need to be able to add the inter-DB access to an existing database role (for compatibility with existing systems). How can I go about doing this?
                        

Asked by jamesyjamesjames (63 rep)

Oct 27, 2015, 12:57 PM
Last activity: Oct 28, 2015, 03:17 PM

Is it possible to add a certificate to a database role?

Related Questions