Post reply

Permission Issues.

  • July 9, 2009 at 12:03 am

    #155935

    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

    #1022179

    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