1 Version 4.0 -- 1/15/89 sp_helpgroup
______________________________________________________________________
NAME: sp_helpgroup
FUNCTION:
Reports information on a group or on all groups in the current
database.
SYNTAX:
sp_helpgroup [grpname]
EXAMPLES:
1) sp_helpgroup hackers
sp_helpgroup Version 4.0 -- 1/15/89 2
______________________________________________________________________
Displays information about the hackers group:
Group_name Group_id Users_in_group Userid
-------------- ---------- -------------- ------
hackers 16384 ann 4
hackers 16384 judy 3
(3 rows affected)
2) sp_helpgroup
Displays information about all the groups in the current
database:
Group_name Group_id
------------- --------
hackers 16384
3 Version 4.0 -- 1/15/89 sp_helpgroup
______________________________________________________________________
public 0
(2 rows affected)
PARAMETERS:
grpname - is the name of a group in the database that has been
created with sp_addgroup.
COMMENTS:
o Executing sp_helpgroup reports on the specified group or, if no
parameter is supplied, on all groups in the database.
o To get a report on the default group, public, enclose the name
``public'' in single or double quotes (public is a reserved
word).
sp_helpgroup Version 4.0 -- 1/15/89 4
______________________________________________________________________
MESSAGES:
The specified group does not exist in the current database. Exe-
cute the procedure without the grpname parameter to see a
list of all the groups in the database.
PERMISSIONS:
Execute permission to public.
TABLES USED:
sysusers
SEE ALSO:
sp_addgroup, sp_changegroup, sp_dropgroup, sp_helprotect,
sp_helpuser, GRANT, REVOKE