NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-27
Examples—ALTER PROGRAM
The following dependencies apply when you alter program security attributes:
Examples—ALTER PROGRAM
•
The following statements give the program file ASERV to a new owner (12,201)
and set the PROGID file attribute. The first statement sets the owner ID, which
automatically turns off the PROGID attribute. The second statement turns on the
PROGID attribute.
ALTER PROGRAM ASERV OWNER 12,201;
ALTER PROGRAM ASERV PROGID;
ALTER TABLE Statement
ALTER TABLE is a DDL statement that does the following:
•
Renames, changes security, changes file attributes, or enables or disables similarity
checks for a table
•
Adds a column to a table or changes the HEADING attribute for an existing column
•
Drops, moves, splits, reuses, or adds a table partition, or changes file attributes of a
table partition
The ALTER TABLE statement supports several types of move and split operations,
including:
•
Moving an entire partition to another disk volume
•
Merging an entire partition into another existing partition
•
Splitting a partition and moving part into a newly created partition
•
Moving part of a partition into another existing partition
OWNER and PROGID Specifying OWNER turns off the PROGID attribute.
OWNER and
SECURE
A change in the ownership of a program affects the
interpretation of the security string. The security string is
interpreted at run time against the new owner and, if
applicable, a new group.
If another process is using a program when the owner or
security string is changed, the process might not be able to
access the program after the program stops executing.
SECURE A security string must ensure that users who have write access
also have read access.