Chapter 1: System Procedures

sp_revokelogin

Description

Windows NT 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

login_name: is the network login name of the Windows NT user.

group_name: is the Windows NT group name.

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:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect