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

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Installation and Management Guide—544536-007
9-25
Altering Triggers
Altering Table Privileges
To alter table privileges, use the GRANT and REVOKE statements.
For more information, see the SQL/MX Reference Manual.
Steps for Altering a Table’s Privileges
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 table you want to alter and what privileges you want to
change.
3. Enter the GRANT or REVOKE statement.
For more information and examples of altering table privileges, see the SQL/MX
Reference Manual.
Altering Triggers
To alter triggers, use the ALTER TRIGGER statement.
You can alter triggers by either enabling or disabling them with the ALTER TRIGGER
statement.
For more information, see the SQL/MX Reference Manual.
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.