Post reply

Permission to Stored permission

  • September 3, 2008 at 7:38 am

    #193112

    Hi All,

    There is login called ReportUser

    This login has db_datareader permission, additonally I want to give permission for executing dbo Stored Procedure also.

    Can anyone help me for providing scripts or navigation to providing the rights.

    Thanks in advance for any help.

    Regards,

    Mohanraj Jayaraman

  • September 3, 2008 at 7:54 am

    #866484

    You can either add a SQL statement at the end of the Procedure to allow the user Exec Permissions.

    Grant EXECUTE ON [ProcName] TO [UserName];

    or

    in Management Studio, right click on the user under the Logins...go to the Securables section...and from there you can any object with the specific permissions...

  • September 3, 2008 at 7:58 am

    #866488

    Thank You,

    It worked for me.

    Regards,

    Mohanraj Jayaraman

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply