sp_helpntgroup

Transact-SQL Reference

Transact-SQL Reference

sp_helpntgroup

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

Syntax

sp_helpntgroup [ [ @ntname = ] 'name' ]

Arguments

[@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).

Return Code Values

0 (success) or 1 (failure)

Result Sets
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.
Remarks

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

Permissions

Execute permissions default to the public role.

Examples

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

EXEC sp_helpntgroup

See Also

sp_grantdbaccess

sp_helprole

sp_revokedbaccess

System Stored Procedures