IBM Netfinity 5100 8658 21Y, Manual

Page: 138 / 246

Manager for OS/2, Netfinity Manager for Windows 95,
or Netfinity Manager for Windows NT has been
installed:
a. Open a DB2 command window.
b. In the DB2 command window, type the following
command:
DB2 BIND x: \ directory \DB2SQLC0.bnd
where x: \ directory is the name of the drive and
directory where Netfinity Manager is installed.
c. Press Enter.
Granting and revoking database privileges
The following information describes how to grant and
revoke database privileges.
Note: If your primary system is OS/2, refer to “Database
privileges on OS/2 systems” on page 129.
1. Start a DB2 command window.
Notes:
a. If it is not already running, start the DB2 database
manager.
b. If you are not connected to the DB2 Netfinity
database, connect to the database now.
2. Type the following command:
DB2 GRANT privilegecode ON TABLE tablename TO
userid
where
v privilegecode is one of the following privilege codes:
– ALL
– ALL PRIVILEGES
Note: Grants all the appropriate privileges,
except CONTROL, on the database.
– ALTER
– CONTROL
– DELETE
– INDEX
– INSERT
– REFERENCES
– SELECT
– UPDATE
v 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).
128
: Netfinity 5100 Type 8658 Models 11Y, 21Y, 31Y,
41Y, 51Y, 1RY, 2RY, 3RY, 4RY, 5RY