Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Reports information about Windows groups with accounts in the current database.
Transact-SQL syntax conventions
Syntax
sp_helpntgroup [ [ @ntname = ] N'ntname' ]
[ ; ]
Arguments
[ @ntname = ] N'ntname'
The name of the Windows group. @ntname is sysname, with a default of NULL. @ntname must be a valid Windows group with access to the current database. If @ntname isn't specified, all Windows groups with access to the current database are included in the output.
Return code values
0 (success) or 1 (failure).
Result set
| Column name | Data type | Description |
|---|---|---|
NTGroupName |
sysname | Name of the Windows group. |
NTGroupId |
smallint | Group identifier (ID). |
SID |
varbinary(85) | Security identifier (SID) of NTGroupName. |
HasDbAccess |
int | 1 = Windows group has permission to access the database. |
Remarks
To see a list of the SQL Server roles in the current database, use sp_helprole.
Permissions
Requires membership in the public role.
Examples
The following example prints a list of the Windows groups with access to the current database.
EXECUTE sp_helpntgroup;