locked
update Permissions RRS feed

Answers

  • CREATE PROCEDURE spUpdateEMP

    @par INT

    AS

    UPDATE EMP SET col=@par WHERE..

     

    ---

    GRANT EXEC ON  spUpdateEMP  TO testuser-- Grant permission on a single procedure.


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by amber zhang Tuesday, December 20, 2011 1:53 AM
    • Marked as answer by amber zhang Monday, December 26, 2011 8:32 AM
    Monday, December 19, 2011 6:16 AM