开发者

SQl server 2008 permission and encryption

开发者 https://www.devze.com 2022-12-22 12:29 出处:网络
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开发者_如何转

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


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

0

精彩评论

暂无评论...
验证码 换一张
取 消