Search code examples
sqlsql-serverdatabase-administrationsql-grant

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?

Solution

  • CREATE MASTER KEY

    Permissions

    Requires CONTROL permission on the database.