Cannot Delete Users - CREATE TABLE Permission Denied In Database '[ORCHESTRATOR_DB_NAME]' When Deleting Users

Error fix for " CREATE TABLE Permission denied in database '[ORCHESTRATOR_DB_NAME]' when deleting users" .

Issue Description: Receiving this error when deleting a user,

  • CREATE TABLE Permission denied in database '[ORCHESTRATOR_DB_NAME]' when deleting users


Resolution

Make sure the login is a member of the db_owner role. If security restrictions does not allow to use the db_owner user mapping role with the login, grant the following:

db_datareader

db_datawriter

db_ddladmin

EXECUTE permission on dbo .