I used the UI to add a user to have explicit permissions on a SProc. Now, I want to remove them from the permissions altogether from just that SProc. When I click on the user, the Remove button does not become available. How can I remove this user?
But I don't necessarily want to DENY EXECUTE permissions. I just want to remove any specification in that UI dialogue. This user already has DBO permissions. Adding this user in the dialogue was a mistake.