Permission Issues.

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  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

• SQL DBA-909494

  SSCommitted

  Points: 1605

  More actions

  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":-) **