sp_helpntgroup (Transact-SQL)

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

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_helpntgroup [ [ @ntname= ] 'name' ] 

Arguments

  • [ @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.

Return Code Values

0 (success) or 1 (failure)

Result Sets

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

See Also

Reference

Security Stored Procedures (Transact-SQL)
sp_grantdbaccess (Transact-SQL)
sp_helprole (Transact-SQL)
sp_revokedbaccess (Transact-SQL)
System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance