Enable user to execute a sys stored procedure

  • I am struggling to enable a user to be able to execute a system stored procedure (sys.sp_droprolemember) with no luck.

    How am I supposed to do that ?

    I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember

    TO John;

    GO

     

    but I get :

    Cannot find the object 'droprolemember', because it does not exist or you do not have permission.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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