| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_helpntgroup (Transact-SQL) |
sp_helpntgroup reports information about Windows groups with accounts in the current database. |
markingmyname |
maghan |
randolphwest |
05/15/2024 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Reports information about Windows groups with accounts in the current database.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_helpntgroup [ [ @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.
0 (success) or 1 (failure).
| 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. |
To see a list of the [!INCLUDE ssNoVersion] roles in the current database, use sp_helprole.
Requires membership in the public role.
The following example prints a list of the Windows groups with access to the current database.
EXEC sp_helpntgroup;