IBM 8658 User Guide - Page 109

Database, privileges, systems

Get IBM 8658 - Eserver xSeries 230 PDF manuals and user guides
UPC - 087944602644
View all IBM 8658 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 109 highlights

where v 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 v 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. 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 Netfinity Manager 99

  • 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
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
where
v
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
v
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.
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
Netfinity
Manager
99