sp_helpntgroup (T-SQL)

Reports information about Microsoft® Windows NT® groups with accounts in the current database.

sp_helpntgroup [[@ntname =] 'name']

[@ntname =] 'name': Is the name of the Windows NT group. name is sysname, with a default of NULL. name must be a valid Windows NT group in the current database. If name is not specified, all Windows NT groups in the current database are included in the output. Specify the name that the Windows NT group is known by in the database (added using sp_grantdbaccess).

0 (success) or 1 (failure)

Column name	Data type	Description
NTGroupName	sysname	Name of the Windows NT group.
NTGroupId	smallint	Group ID.
SID	varbinary(85)	Security identifier of NTGroupName.
HasDbAccess	int	1 = Windows NT group has permission access to the database.

To see a list of the Microsoft SQL Server™ roles in the current database, use sp_helprole.

Execute permissions default to the public role.

This example prints a list of the Windows NT groups in the current database.

EXEC sp_helpntgroup

sp_grantdbaccess	sp_revokedbaccess
sp_helprole	System Stored Procedures