REVOKE CONNECT Statement
Removes a user from the database.
Syntax
REVOKE CONNECT FROM <userID> [,...]
Parameters
- must be the name of an existing user or role that has a login password. Separate multiple userIDs with commas.
Usage
Use system procedures or CREATE USER and DROP USER statements, not GRANT and REVOKE statements, to add and remove user IDs.
You cannot revoke the connect privileges from a user if he or she owns database objects, such as tables. Attempting to do so with a REVOKE statement, or sp_droplogin or sp_iqdroplogin stored procedure returns an error such as Cannot drop a user that owns tables in runtime system.
Standards
ANSI SQL–compliance level: Transact-SQL extension.