Revoking integrated login permission

You can remove an integrated login mapping using Interactive SQL.

StepsRevoking an integrated login permission (SQL)

  1. Connect to a database with DBA authority.

  2. Execute a REVOKE INTEGRATED LOGIN FROM statement.

Example

The following SQL statement removes integrated login permission from the Windows user pchin.

REVOKE INTEGRATED LOGIN
FROM pchin

For more information, see REVOKE statement in Reference: Statements and Options.