IBM 4500R Hardware Maintenance Manual - Page 93

Granting and revoking database privileges, Notes, Database privileges on OS/2 systems

Get IBM 4500R - Netfinity - 8656 PDF manuals and user guides
UPC - 087944567837
View all IBM 4500R manuals
Add to My Manuals
Save this manual to your list of manuals

Page 93 highlights

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". 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: Netfinity Manager 85

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
Netfinity Manager
85
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
”
.
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: