IBM 6000R Hardware Maintenance Manual - Page 134

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". 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 • 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 • 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. • 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: 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.DB2SQLC0 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: 122 Netfinity 6000R Type 8682 Models 1RY, 2RY