Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQl server 2008 permission and encryption

i have made columns in some of the tables encrypted in sql server 2008. Now as i am a db owner i have the access to encode and decode the data using the symmetric key and certificate. But some other users have only currently datareader and datawriter rights ,and when they execute any SP referring the logic which uses the key and certificate "User does has not right on the certificate to execute". What rights / exact permission should i grant them just to solve this problem

like image 333
paranjai Avatar asked Mar 14 '26 14:03

paranjai


1 Answers

Thanks to Dynamo ,the solution is GRANT CONTROL ON CERTIFICATE :: certificate_name TO username

https://serverfault.com/questions/122851/sql-server-2008-permission-and-encryption

like image 185
paranjai Avatar answered Mar 16 '26 06:03

paranjai



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!