SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

What’s New in This Manual

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

xxxvi

New and Changed Information

Changes to 663850-001 manual:

•

Security:

Updated the section Security on page 1-5.

Added GET ALL SECURITY_ADMINS Statement on page 2-193.

Added GIVE CATALOG Statement on page 2-195.

Added GIVE Object Statement on page 2-196.

Updated Considerations for GRANT on page 2-200.

Added GRANT CREATE CATALOG Statement on page 2-201.

Added GRANT CREATE SCHEMA Statement on page 2-202.

Added GRANT SECURITY_ADMIN Statement on page 2-205.

Updated Considerations for REVOKE on page 2-233.

Added REVOKE CREATE CATALOG Statement on page 2-234.

Added REVOKE CREATE SCHEMA Statement on page 2-235.

Added REVOKE SECURITY_ADMIN Statement on page 2-238.

Added GIVE SCHEMA Operation on page 5-29.

Added RECOVER SCHEMA Operation on page 5-126.

Added Metadata tables, MGM_PRIVILEGES on page 10-11 and

PRIVILEGED_USERS TABLE on page 10-11.

•

DDL Statements:

Updated Authorization and Availability Requirements section in SQL/MX

Statements on page 2-1.

Updated ALTER INDEX Statement on page 2-8 and ALTER TABLE Statement

on page 2-12.

Added Altering the MAXVALUE and INCREMENT BY options on IDENTITY

columns on page 2-27.

Added ALTER VIEW Statement on page 2-41.

Updated CREATE TABLE Statement on page 2-95.

Added Generating Values for an IDENTITY Column on page 2-121.

Added new content in Examples of CREATE TABLE on page 2-125.

Updated CREATE VIEW Statement on page 2-142.