Its quite common that sometime we give role that doesn't suit with the actual requirement.
Unfortunately, your current permission doesn't match with the requirement for given role. Refer below screenshot...
Now executing below statement/permission with Sysadmin rights can allow particular user to run the DDL statements.
ALTER ROLE db_ddladmin ADD MEMBER gaur
Best Regards
Amit Vaid
No comments:
Post a Comment