Permissions on Symmetric Keys

• Mike Wootten

  SSC Enthusiast

  Points: 159

  More actions

  July 26, 2011 at 6:09 am

  #390052

  Hi,

  I'm pulling out what little hair I have...

  OPEN SYMMETRIC KEY myKey DECRYPTION

  BY CERTIFICATE myCert

  DECLARE @pwtemp varbinary(256)

  SET @pwtemp=(SELECT ENCRYPTBYKEY(KEY_GUID('myKey '),'test'))

  PRINT @pwtemp

  This will work fine under Windows Authentication but not under a SQL Server login I'm using.

  I get the following error:

  Cannot find the symmetric key 'myKey', because it does not exist or you do not have permission.

  I've tried:

  GRANT view definition ON CERTIFICATE::myCert to testuser1

  with no affect.

  Is there anything more I need to do to the login to make this work?

  Cheers

• winash

  SSChampion

  Points: 11446

  More actions

  July 27, 2011 at 6:43 am

  #1359176

  Would this help -> http://msdn.microsoft.com/en-us/library/ms179887(v=SQL.100).aspx