Post reply

stored proc permissions

  • November 18, 2008 at 5:01 am

    #125908

    Hi All,

    Does anyone perhaps know what the system stored proc is to check what permissions a stored procedure has?

    Regards

    IC

  • November 18, 2008 at 7:40 am

    #899924

    Hi,

    You can use sp_helprotect 'mysproc' to find out the permissions granted on the stored procedure.

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 18, 2008 at 7:48 am

    #899930

    Thanks alot!

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

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