Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_helpntgroup (Transact-SQL)

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

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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.