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

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Installation and Management Guide—523723-004
9-26
Altering Views
Steps for Altering a Trigger
1. Start an MXCI session. Enter a LOG command to initiate a log file for statements
and commands entered in this session. Keep the log for your records.
2. Determine the name of the trigger you want to alter.
3. Enter the ALTER TRIGGER statement.
For more information and examples of altering triggers, see the SQL/MX Reference
Manual.
Altering Views
To alter view privileges, use the GRANT and REVOKE statements.
For more information, see the SQL/MX Reference Manual.
Steps for Altering a View
1. Start an MXCI session. Enter a LOG command to initiate a log file for statements
and commands entered in this session. Keep the log for your records.
2. Determine the name of the view you want to alter.
3. Enter the GRANT or REVOKE statements.
For more information and examples of altering views, see the SQL/MX Reference
Manual.