1 Version 4.0 -- 1/15/89 sp_dropuser
______________________________________________________________________
NAME: sp_dropuser
FUNCTION:
Drops a user from current database by deleting the entry from
sysusers.
SYNTAX:
sp_dropuser name_in_db
EXAMPLES:
sp_dropuser albert
sp_dropuser Version 4.0 -- 1/15/89 2
______________________________________________________________________
Drops the user albert from the current database. Albert may no
longer use the database.
PARAMETERS:
name_in_db - is the user's name in the current database's
sysusers table.
COMMENTS:
o Executing sp_dropuser deletes a user from the current database
by deleting the user's row from sysusers.
o Users who own objects in the database cannot be dropped.
o The Database Owner of a database cannot be dropped.
o If other users are aliased to the user being dropped, their
aliases are dropped. They are no longer able to access the
database.
3 Version 4.0 -- 1/15/89 sp_dropuser
______________________________________________________________________
MESSAGES:
The specified user is no longer known to the database.
Other users were aliased to the user being dropped. Their
aliases have been dropped, and they can no longer access the
database.
The specified user doesn't exist in the current database.
The Database Owner cannot be dropped, even by the System Adminis-
trator.
Users who own objects in the current database cannot be dropped.
Drop the owned objects first. When this error message is
generated, a list of objects and their owners is displayed.
Users who own user datatypes in the current database cannot be
dropped. Drop the owned datatypes first. When this error
message is generated, a list of datatypes and their owners is
displayed.
sp_dropuser Version 4.0 -- 1/15/89 4
______________________________________________________________________
PERMISSIONS:
Execute permission to Database Owner.
TABLES USED:
sysalternates, sysobjects, systypes, sysusers
SEE ALSO:
sp_adduser, sp_droplogin, GRANT, REVOKE, USE