sp helpgroup system procedure

GPTKB entity

Statements (23)
Predicate Object
gptkbp:instanceOf system stored procedure
gptkbp:canBe any user
gptkbp:category gptkb:security
gptkbp:deprecatedIn gptkb:SQL_Server_2012
gptkbp:documentation https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-helpgroup-transact-sql
gptkbp:hasSyntax EXEC sp_helpgroup [ [ @grpname = ] 'role_name' ]
https://www.w3.org/2000/01/rdf-schema#label sp helpgroup system procedure
gptkbp:introducedIn gptkb:SQL_Server_2000
gptkbp:parameter @grpname
sysname
gptkbp:permits public
gptkbp:purpose returns information about database roles
gptkbp:replacedBy sys.database_role_members view
gptkbp:result list of roles in the current database
members of each role
gptkbp:returnsColumns Members
Group_id
Group_name
Group_owner
gptkbp:schema dbo
gptkbp:usedIn gptkb:Microsoft_SQL_Server
gptkbp:bfsParent gptkb:Sybase_SQL_dialect
gptkbp:bfsLayer 7