1 Version 4.0 -- 1/15/89 sp_helpuser
______________________________________________________________________
NAME: sp_helpuser
FUNCTION:
Reports information on users of a database.
SYNTAX:
sp_helpuser [name_in_db]
EXAMPLES:
1) sp_helpuser
Displays information about all users in the current database:
sp_helpuser Version 4.0 -- 1/15/89 2
______________________________________________________________________
Users_name ID_in_db Group_name Login_name Default_db
----------- ---------- -------------- ---------- ------------
ann 4 hackers ann master
dbo 1 public sa master
guest 2 public NULL NULL
judy 3 hackers judy master
(4 rows affected)
2) sp_helpuser dbo
Displays information about the user Database Owner:
Users_name ID_in_db Group_name Login_name Default_db
---------- -------- ---------- ---------- ------------
dbo 1 public sa master
3 Version 4.0 -- 1/15/89 sp_helpuser
______________________________________________________________________
Users aliased to user.
Login_name
-------------------------------
andy
christa
howard
linda
PARAMETERS:
name_in_db - is the user's name in the current database. If you
don't specify a name, the procedure reports on all users of
the current database.
COMMENTS:
o Executing sp_helpuser reports information on a specified user,
or on all users, of the database.
sp_helpuser Version 4.0 -- 1/15/89 4
______________________________________________________________________
o If the specified user is not listed in the current database's
sysusers table, the procedure checks to see if the user is
aliased to another user or is a group name.
MESSAGES:
The name specified for the name_in_db parameter is a group name.
If the user has other users aliased to him or her, the names of
the other users are listed.
The name supplied is not a user in the database, but is aliased
to a user in the database.
The name supplied is unknown in the database as a login, user, or
group.
PERMISSIONS:
Execute permission to public.
5 Version 4.0 -- 1/15/89 sp_helpuser
______________________________________________________________________
TABLES USED:
sysalternates, sysusers, master.dbo.syslogins
SEE ALSO:
sp_adduser, sp_dropuser, sp_help, sp_helpgroup, GRANT, REVOKE,
USE