Problem:
I have a user 'TestUser' and it has only read and write permissions yet. but i have to give that user the rights to CREATE and Execute Procedures only. not anything else (to alter the schema).
Please give me the T-SQL for all steps.
I have created a user and GRANT it CREATE PROCEDURE permissions but it gives the error:
The specified schema name "dbo" either does not exist or you do not have permission to use it.
Please guide !!
Thanks,
Noman