sp dropuser system procedure

GPTKB entity

Statements (13)
Predicate Object
gptkbp:instanceOf system stored procedure
gptkbp:category gptkb:security
gptkbp:deprecatedIn gptkb:SQL_Server_2012
gptkbp:hasSyntax sp_dropuser [ @name_in_db = ] 'user'
https://www.w3.org/2000/01/rdf-schema#label sp dropuser system procedure
gptkbp:introducedIn gptkb:SQL_Server_2000
gptkbp:permits ALTER ANY USER
gptkbp:purpose removes a database user from the current database
gptkbp:replacedBy DROP USER statement
gptkbp:requires user must not own any database objects
gptkbp:usedIn gptkb:Microsoft_SQL_Server
gptkbp:bfsParent gptkb:Sybase_SQL_dialect
gptkbp:bfsLayer 7