IBM 865811Y User Guide - Page 108
Activating, database, Granting, revoking, privileges
UPC - 087944531869
View all IBM 865811Y manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 108 highlights
Installing the database on OS/2: 1. Insert the Netfinity Manager CD into the CD-ROM drive (in this example, drive D; individual drive letters might be different). 2. Start an OS/2 window or full-screen session. 3. Make the CD-ROM drive the active drive. Type D: and then press Enter. 4. Type the following command at the OS/2 prompt: NETFINDB CREATE /DBNAME=databasename /DRIVE=d where databasename is the name of the database and d is the drive where the database will be located. Note: If any part of the database already exists, the utility program will create only the portions of the database that are missing. 5. Press Enter. Activating the database The following information describes how to connect, bind, and grant privileges to the database. 1. Connecting to the Database a. Start a DB2 command window. b. Type the following command: DB2 CONNECT TO databasename where databasename is the name of the database as specified in the database installation 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, perform the following 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. 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 99. 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 98 : Netfinity 5100 Type 8658 Models 11Y, 21Y, 31Y, 41Y, 51Y, 1RY, 2RY, 3RY, 4RY, 5RY