Bewerken

Delen via


sp_helpntgroup (Transact-SQL)

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.

EXEC sp_helpntgroup;