– CONTROL
– DELETE
– INDEX
– INSERT
– REFERENCES
– SELECT
– UPDATE
tablename is the name of the table as specified during database
installation. A listing of the Netfinity database table names can be found in
the
Netfinity User's Guide (Appendix H: Netfinity Relational Database
Tables).
Note: The Netfinity Database Administration Tool can also be used to
GRANT or REVOKE privileges. For information on using the
Database Administration Tool, refer to “Creating the Netfinity tables”
on page 53.
userid is the user ID to be granted access
3. Press Enter to execute the command.
To revoke privileges, substitute REVOKE for GRANT in the command line.
Database privileges on OS/2 systems
Note: OS/2 is not supported on the IBM Netfinity 4000R. However, the IBM
Netfinity 4000R can be managed from an OS/2 system.
1. Use the GRANT EXECUTE command to enable Netfinity Manager to access
the database.
Type the following command at the OS/2 prompt:
DB2 GRANT EXECUTE ON PACKAGE NETFIN.DB2SQLCð TO PUBLIC
and then press Enter.
Note: Specify PUBLIC or authorize only specific manager systems. To limit
access to the database, substitute the authorization name of the
managing system for PUBLIC.
2. Use the CONNECT RESET command to disconnect current users from the
database.
Type the following command at the OS/2 prompt:
DB2 CONNECT RESET
and then press Enter.
3. Use the NETFINDB GRANT command to grant (or revoke) database privileges.
To grant or revoke table privileges on OS/2:
a. Insert the Netfinity Manager CD into the CD-ROM drive (in this example,
drive D; individual drive letters might be different).
b. Make 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
48
Netfinity
4000R User's Handbook
Summary of Contents for NETFINITY 4000R
Page 1: ...IBM IBM Netfinity 4000R User s Handbook...
Page 2: ......
Page 3: ...IBM IBM Netfinity 4000R User s Handbook...
Page 12: ...2 Netfinity 4000R User s Handbook...
Page 32: ...22 Netfinity 4000R User s Handbook...
Page 38: ...28 Netfinity 4000R User s Handbook...
Page 48: ...38 Netfinity 4000R User s Handbook...
Page 76: ...66 Netfinity 4000R User s Handbook...
Page 81: ...Section 3 Appendixes Copyright IBM Corp 1999 71...
Page 82: ...72 Netfinity 4000R User s Handbook...
Page 86: ...76 Netfinity 4000R User s Handbook...
Page 88: ...78 Netfinity 4000R User s Handbook...
Page 98: ...88 Netfinity 4000R User s Handbook...
Page 102: ...IBM Part Number 00N9106 Printed in U S A N91 6...