Post reply

MINIMUM PERMISSIONS TO VIEW STORED PROCEDURE

  • June 6, 2006 at 12:03 pm

    #172888

    Anyone know the minimum permissions to allow a user to view the contents of a stored procedure.  In SQL 2000, I could grant "datareader".  This isn't the case in SQL 2005.

     

    Thanks

  • June 6, 2006 at 12:25 pm

    #642117

    I figured it out.

    [VIEW DEFINITION] permission is required

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

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