Post reply

LOGIN MAPPED TO KEY or CERTIFICATE

  • September 7, 2010 at 10:58 pm

    #229077

    Hi Experts,

    This might seems to be a silly question but I wonder what is the use the logins which are mapped to a certificate or asymmetric key??

    TIA

  • September 8, 2010 at 10:27 am

    #1218089

    I would look at this link for details:

    http://msdn.microsoft.com/en-us/library/ms345102.aspx

    The short of it is that these logins are not intended to be server access logins. Rather the corresponding certificate or key is used to sign or encrypt, respectively, various objects in the database such as store procedures, and possibly data. This is used as a second level of authorization that can be temporarily granted to a connecting user or process then revoked when access to the secured object is no longer required.

    Nice security feature for ensuring compliance.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply