G

GENERATED …AS IDENTITY, 411–413

Generating data values, sequences, 217–220

Generic Security Service Application Program Interface (GSS-API), 101, 155

Geodetic Data Management, 44

Geodetic Extender, 55, 58–59, 91, 95–96, 572

Geographic Information Systems (GISs), 58

Global Secure Toolkit, 40

Governor, DB2, 39, 43

GRANT, 111, 112, 127–137, 151, 153, 159, 171, 257, 575, 576, 578, 579

ALL PRIVILEGES clause and, 129, 130, 134–136, 156, 576

Control Center and, granting/revoking of authorities/privileges and, 125–126, 125, 126

database-level, authorities and privileges using, 127

examples of, 135–137

EXECUTE and, 160

index, authorities and privileges using, 130–131

nickname, authorities and privileges using, 134–135

package, authorities and privileges using, 133

requirements for use of, 146, 147t

routine, authorities and privileges using, 131–133

schema, authorities and privileges using, 128

sequence, authorities and privileges using, 131

server, authorities and privileges using, 133–134, 143–144

stored procedures and, 160

table, authorities and privileges using, 129

table space, authorities and privileges using, 128

view, authorities and privileges using, 130

WITH GRANT OPTION and, 124, 128

Granting authorities and privileges, 123–147

Granularity

locks, data concurrency and, 484–485

triggers and, 221, 439

GRAPHIC. See fixed-length character data type

Graphical user interface (GUI), 60

Greater than or equal to, 272–274. See also comparison operators; relational predicates

Greater than, 272–274. See also comparison operators; relational predicates

GRECP, 6

GROUP BY, 79, 210, 227, 268, 271, 280–281, 358, 359, 592, 595

indexes and, 210

user-defined data types and, 227

GROUP BY CUBE clause, SELECT and, 283–284

GROUP BY ROLLUP clause, SELECT and, 281–282

Grouping expressions, 282

GSS_SERVER_ENCRYPT, 101, 155, 573

GSSPLUGIN, 573, 581