90 Net finity 3500 -M20 – T ype 8657 Mod els 21 Y, 2 2Y, 31Y, 32Y ,
finity database table names can be found in the
Netfinity User’ s Guide
(Appendix H: Netfinity Rela-
tional Database Tables).
Note: The N etfinity Database Administrat ion Tool
can also be used to GRANT or REVOKE
privileges.
•
userid
is the user ID to be granted access
3. Pr es s E nt er to ex ec ute the com m an d.
To revoke privileges, substitute REVOKE for GRANT in the
command line.
Database privile ges on OS/2 systems:
1. Use the GRANT EXECUTE command to enable Netfin-
ity Manager to access the dat abase.
Type the following command at the OS/2 prompt:
DB2 GRANT EXECUTE ON PACKAGE NETFIN.DB2SQLC0 TO
PUBLIC
and then pr ess Ent er.
Note: Specify PUBLIC or authorize only specific man-
ager systems. To limit access to the database,
substitute the authorization name of the manag-
ing system for PUBLIC.
2. Use the CONNECT RESET command to disconnect
curr ent users from the database.
Type the following command at the OS/2 prompt:
DB2 CONNECT RESET
and then pr ess Ent er.
3. Use the NETFINDB GRANT command to grant (or
revoke) database privileges.
To grant or revoke table privileges on OS/2:
a. Insert the Netfinit y Manager CD int o the C D-ROM
drive (in this example, drive D; individual drive let-
ters might be different).
b. Mak e the CD-ROM drive the active drive.
Type D: and then press Enter.
c. Type the following command:
NETFINDB GRANT /ID=id PUBLIC
/DBNAME=databasename /PRIV=privilegecode
where
•
id
is the user ID to be granted access
•
databasename
is the name of the dat abase
as s peci fied during NETFINDB exec ution
•
privilegecode
is on e of th e fo ll o win g pri vi le ge
code s:
—ALL
—ALTER
— CONTROL
— DELETE
— INDEX
— INSERT
— REFERENCES
— SELECT
—UPDATE
d. Pr es s E nt er to ex ec ute the com m an d.