Post reply

how to grant permission

  • March 10, 2010 at 11:18 am

    #386475

    Hi,

    I have created a stored procedure which will be called in a .net code,there is a URL and whenever anybody make changes in that URL the .net code will call my procedure and update the tables according to it .

    but looks like i don't have permissons to it ,i.e. whenever anyone is changing the URL it is not calling my procedure ...

    Can anyone tell me how to grant permissions to execute?

  • March 10, 2010 at 11:42 am

    #1131594

    How does the .NET code connect? the login used, an the user mapped to it, need permissions to the proc.

    a GRANT EXECUTE ON (proc) to XXX will work, but you need to know the xxx.

  • March 10, 2010 at 12:50 pm

    #1131627

    Thank You .I got it.

  • March 10, 2010 at 12:55 pm

    #1131630

    One more suggestion along with how to grant the permissions is to grant the permissions to a role. Then add that user to the role rather than granting permissions directly to the user. Should you need to change the user, it will be easier to drop the new user into the role than recreate the permissions.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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