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 .