Note:
The Netfinity Database Administration Tool
can also be used to GRANT or REVOKE
privileges.
v
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:
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
where
v
id
is the user ID to be granted access
v
databasename
is the name of the database as
specified during NETFINDB execution
v
privilegecode
is one of the following privilege
codes:
– ALL
– ALTER
– CONTROL
– DELETE
– INDEX
Netfinity Manager
129
Summary of Contents for Netfinity 5100 8658 21Y
Page 1: ...Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY S10K 2615 00...
Page 10: ...x Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 26: ...16 Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 50: ...40 Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 65: ...13 PCI slot 2 32 bit J32 Installing options 55...
Page 195: ...Parts listing Type 8658 Copyright IBM Corp 2000 185...
Page 196: ...186 Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 215: ...Related service information 205...
Page 216: ...206 Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 217: ...Related service information 207...
Page 218: ...208 Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 219: ...Related service information 209...
Page 220: ...210 Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 221: ...Related service information 211...
Page 222: ...212 Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 235: ...Related service information 225...
Page 236: ...226 Netfinity 5100 Type 8658 Models 11Y 21Y 31Y 41Y 51Y 1RY 2RY 3RY 4RY 5RY...
Page 237: ...Related service information 227...
Page 245: ......
Page 246: ...Part Number 10K2615 Printed in U S A S10K 2615 00 1P P N 10K2615...