SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Creating an SQL/MX Database
HP NonStop SQL/MX Installation and Management Guide—544536-007
7-11
Examples for Granting Privileges
Use the WITH GRANT OPTION to specify that users to which privileges are granted
are authorized to grant the same privileges to other authorization IDs.
To grant a privilege on an SQL/MX table or view, you must have that privilege and also
have the right to grant that privilege. That is, the privilege must be issued to you
through the WITH GRANT OPTION and not have been revoked.
Granting privileges on a view does not grant that privilege to the corresponding column
of the underlying table.
For more information about the GRANT and GRANT EXECUTE statements, see the
SQL/MX Reference Manual.
Examples for Granting Privileges
This example grants SELECT privileges on a table, but not the privilege of granting
SELECT privileges to others:
GRANT SELECT ON TABLE persnl.employee TO "sql.user1";
This example grants SELECT and DELETE privileges on a table, including the
privilege of granting SELECT and DELETE privileges to others:
GRANT SELECT, DELETE ON TABLE sales.odetail
TO "sql.user1", "sql.user2" WITH GRANT OPTION;
This example grants UPDATE privileges on the named columns to PUBLIC:
GRANT UPDATE (start_date, ship_timestamp)
ON TABLE persnl.project to PUBLIC;
Revoking Access Privileges
Use the REVOKE statement to revoke access privileges for an SQL/MX table or view
from specified users. For more information, see the SQL/MX Reference Manual.
Access Privileges for SQL/MX Utilities
For information about the minimum user privileges required to access the SQL/MX
utilities, see the SQL/MX Reference Manual.
Creating SQL/MX Tables
Tables are the foundation of an SQL/MX database. All data physically resides in tables.
When you create a table with the CREATE TABLE statement, you specify the definition
of each data column and the attributes of the physical file in which the table is to be