Eduardo de Santana Eduardo de Santana - 1 year ago 100
SQL Question

GRANT FOR CREATE MASTER KEY ENCRYPTION

When I perform this command: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'mypassword' I get the error:

[Microsoft][ODBC SQL Server Driver][SQL Server]User does not have permission to perform this action.

Have any GRANT that I need take for this User?

Answer Source

CREATE MASTER KEY

Permissions

Requires CONTROL permission on the database.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download