Index

G

GENERATED AS IDENTITY columns

ProductCatalog database, 396, 398

GETDATE function, 16, 129

GLOBAL parameter, 294

GLOBAL scope, cursors, 236

Globally Unique Identifier (GUID)

ProductCatalog database, 395

GRANT command, 304

Access, 307

authorization, 304

DB2, 324

MySQL, 325, 326

object-level permissions, 305

Oracle, 316, 317, 320

RDBMSs implementing, 305

SQL Server, 311, 313

SQL99 syntax, 305

statement-level permissions, 305

WITH GRANT OPTION

DB2, 322

Oracle, 319

grant tables

MySQL, 324

granting permissions

permissions to roles, 469

roles to users, 466

GROUP BY clause, 90

ALL keyword, 92

ProductCatalog database, 428, 430

using aliases with, 96

grouping data, 90, 322

GUID data type, 537