sys.sp_revokedbaccess

Description

Removes a database user from the current database.

Syntax

sp_revokedbaccess [ @name_in_db = ]
N
'name_in_db'
[ ; ]

Remarks

Removes a database user from the current database.

The name of the database user to be removed.

@name_in_db

, with no default.

@name_in_db

can be the name of a server login, a Windows login, or a Windows group, and

must exist in the current database. When you specify a Windows login or Windows group,

specify the name by which it’s known in the database.

(success) or

This feature will be removed in a future version of SQL Server. Avoid using this feature in

new development work, and plan to modify applications that currently use this feature.

Examples

Example 1

sp_revokedbaccess

Example 2

sp_revokedbaccess

Example 3

Edmonds\LolanSo

Example 4

EXECUTE sp_revokedbaccess
'Edmonds\LolanSo'
;
GO