sp_revokelogin

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.

sp_revokelogin {login_name | group_name}

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

sp_revokelogin jeanluc

Revokes all roles from the Windows NT Administrators group:

sp_revokelogin Administrators

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.

Only a System Administrator can execute sp_revokelogin.

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