SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
9-25
Altering Triggers
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.
3. Enter the GRANT or REVOKE statements.
For more information and examples of altering views, see the
SQL/MX Reference
Manual.