Post reply

Read autorization of SP WITHOUT execute/update right possible?

  • September 9, 2010 at 8:54 am

    #225950

    A request reached my desk to allow some1 to read stored procedures in a certain database, but not be able to change that proc and no execute right.

    Don't ask why, I did that already.

    At first hand I can't think of a way to accomplish that, but maybe I am wrong. Can any1 think of a way to accomplish this?

    Just curious.

    Greetz,
    Hans Brouwer

  • September 9, 2010 at 8:56 am

    #1218686

    i think you can give permission as view definition for a specific SP/s

    ----------
    Ashish

  • September 9, 2010 at 9:07 am

    #1218696

    GRANT VIEW DEFINITION ON <object name> TO <user name>

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 20, 2010 at 3:57 am

    #1223879

    Right!

    Tnx a lot.

    Greetz,
    Hans Brouwer

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

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