User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 13-9
Figure 13-8. Catalog and View Pane.
Display Dependencies
Before altering a view, you can analyze the impact of altering it:
• To display the programs that depend on the table, click tab
Dependent Programs. Programs which would be invalidated by
moving the partition are displayed.
• To display all objects, including programs, that depend on the table,
click tab Dependent Objects. All SQL objects that depend on the
table are displayed.
Change the Column Heading
To change a column heading in the view, perform the following steps.
Refer to Figure 13-9 for an example of the Column pane in the Alter View
window.
Place the cursor in the Heading field and edit the text.
Figure 13-9. Column Pane in Alter View Window.
Change Security
Assign a security string in the Security pane, as shown in Figure 13-10.
You cannot change a protection view’s group ID or owner ID.
1. Use the drop-down lists in the R, W, E, and P fields in the Security
pane.