Post reply

Permissions ro run and view metadata for specific Stored procedures

  • December 23, 2008 at 4:19 pm

    #125987

    How do I grant permissions for a non-DBA to run and view all metadata for sp_helprotect, sp_helpuser, sp_helprolemember?

  • December 23, 2008 at 4:38 pm

    #917157

    Add that non-dba guy as an valid login on server and then he will be able to view metadata by executing sp_helptext [stored procedure name] command in SSMS.

    MJ

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

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