Enable user to execute a sys stored procedure

• SZ

  Old Hand

  Points: 338

  More actions

  July 7, 2020 at 1:54 am

  #3767878

  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.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 8, 2020 at 2:10 am

  #3768269

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

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