sp helpuser system procedure
GPTKB entity
Statements (25)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
system stored procedure
|
| gptkbp:canBe |
members of db_accessadmin role
members of db_owner role members of db_securityadmin role |
| gptkbp:deprecatedIn |
gptkb:SQL_Server_2012
|
| gptkbp:documentation |
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-helpuser-transact-sql
|
| gptkbp:hasSyntax |
sp_helpuser [ [ @name_in_db = ] 'name_in_db' ]
|
| https://www.w3.org/2000/01/rdf-schema#label |
sp helpuser system procedure
|
| gptkbp:introducedIn |
gptkb:SQL_Server_2000
|
| gptkbp:parameter |
@name_in_db
sysname |
| gptkbp:parameterOptional |
true
|
| gptkbp:purpose |
returns information about database users
|
| gptkbp:replacedBy |
sys.database_principals
sys.database_role_members |
| gptkbp:result |
roles
user ID user name default schema login name database role membership |
| gptkbp:schema |
dbo
|
| gptkbp:usedIn |
gptkb:Microsoft_SQL_Server
|
| gptkbp:bfsParent |
gptkb:Sybase_SQL_dialect
|
| gptkbp:bfsLayer |
7
|