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

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

See also

Commands grant, revoke, setuser

System procedures sp_droplogin, sp_dropuser, sp_logininfo