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
|