I need to give alter login permissions to user1 (who is not a super user) for user2 so user1 can enable or disable user2 login.
I granted user1 permissions -
GRANT CONTROL ON LOGIN::User2 to User1 WITH GRANT OPTION;
Then User1 logged in and executed this command, however it didn't work.
REVOKE Connect SQL From User2
Error: Grantor does not have GRANT permission.
Can someone please help?