gillrowley
Programmer
How do I create a SQL Server 2005 database role that has encryption/unencryption permissions? I don't want to make a database User a database owner. Is there a "GRANT" parameter to allow a role to encrypt/unencript
I want to do something like this:
CREATE ROLE db_encryption
GRANT ENCRYPTION TO db_encryption
Obviously, the above doesn't work, but I hope there's an equivalent. Thanks.
I want to do something like this:
CREATE ROLE db_encryption
GRANT ENCRYPTION TO db_encryption
Obviously, the above doesn't work, but I hope there's an equivalent. Thanks.