July 9, 2009 at 12:03 am
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
July 9, 2009 at 1:11 am
Check if you have full access to the database. Also you can use the enterprise manager --> DAtabase--> Stored proc --> go to the tab where you have permission option & check the 'Execute' option
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply