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
but I get :
Cannot find the object 'droprolemember', because it does not exist or you do not have permission.