Netfinity Manager 89
Activating the database
The following information describes how to connect, bind,
and grant privileges to the database.
1. Connecting to the Database
a. St ar t a DB2 co mma nd wi nd ow.
b. Type the following command:
DB2 CONNECT TO databasename
where
databasename
is the name of the database
as s pecified in the database installa tion step.
c. Press Enter.
2. Bind the package and the database
To prepare SQL statements stored in the bind file and
store the package in the database, per form the follow-
ing steps from a system on which Netfinity Manager for
OS/2, Netfinity Manager for Windows 95, or Netfinity
Manager for Windows NT has been installed:
a. Ope n a DB2 command window.
b. In the DB2 command win dow, 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 f ol l owi ng in fo rmat i on descr i be s h ow t o gra nt an d re vok e
database privileges.
Note: If your primary system is OS/2, refer to “Database
privileges on OS/2 systems” on page 90.
1. St ar t a DB2 co mma nd wi nd ow.
Notes:
a. If it is not a lready running, start the DB2 database
manager.
b. If you are not connected to the DB2 Netfinity data-
base connect to the database now.
2. Type the following command:
DB2 GRANT privilegecode ON TABLE tablename TO userid
where
•
privilegecode
is one of the following privilege
codes:
—ALL
— ALL PRIVILEGES
Note: Grants all the appropriate privileges,
ex cept CONTROL, on the database.
—ALTER
— CONTROL
— DELETE
— INDEX
— INSERT
— REFERENCES
— SELECT
—UPDATE
•
tablename
is the name of the table as specified
during database installation. A listing of the Net-