Export (0) Print
Expand All
Expand Minimize

sp_helpntgroup (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

sp_helpntgroup [ [ @ntname= ] 'name' ] 

[ @ntname = ] 'name'

Is the name of the Windows group. name is sysname, with a default of NULL. name must be a valid Windows group with access to the current database. If name is not 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 SQL Server 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;

Community Additions

ADD
Show:
© 2014 Microsoft