sp_revokelogin

Description

(Windows only) Revokes Adaptive Server roles and default permissions from Windows NT users and groups when Integrated Security mode or Mixed mode (with Named Pipes) is active.

Syntax

sp_revokelogin {login_name | group_name}

Parameters

Examples

Example 1

Revokes all permissions from the Windows NT user named “jeanluc”:

sp_revokelogin jeanluc

Example 2

Revokes all roles from the Windows NT Administrators group:

sp_revokelogin Administrators

Usage

• Use sp_revokelogin only when Adaptive Server is running in Integrated Security mode or Mixed mode, when the connection is Named Pipes. If Adaptive Server is running in Standard mode, or in Mixed mode using a connection other than Named Pipes, use the revoke command.

• If you revoke a user’s roles and default privileges with sp_revokelogin, that user can no longer log into Adaptive Server over a trusted connection.

Permissions

Only a system administrator can execute sp_revokelogin.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

See also