• What do you call disable the login?

    If it is "ALTER LOGIN ... DISABLE", I tried it but it doesn't seem to work for windows groups...:(

    I have found a "DENY CONNECT SQL TO ..." that seems to work but it is quite dangerous since it is a DENY permission (unexpected lock outs).

    I wanted to avoid to revoke permissions from the database since there are object level permissions (--> hard to maintain permissions) but you may be right!?

    I was hoping for a magic bullet...

    Thanks anyway! 😎