NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-9
Considerations—SECURE Command
OWNER { group-name.user-name }
{ group-number, user-number }
specifies the Guardian user ID of the user who will be given ownership of the object
or file. (See Security on page S-11 if you need an explanation of the contents of a
Guardian user ID.)
If you do not specify the OWNER option, the ownership of the object remains
unchanged.
PROGID [ ON | OFF ]
determines the process accessor ID of a program file when the program executes.
If you omit the PROGID option, the file attribute is not changed.
PROGID ON is the default if you specify PROGID but omit ON and OFF.
[ NO ] LISTALL
specifies whether you want SECURE to display the name of each resecured file or
object in the following form:
object-type $volume.subvol.name SECURED
object-type is COLLATION, FILE, PROGRAM, PVIEW, SVIEW, or
TABLE.
LISTALL is the default. NO LISTALL suppresses the display.
Considerations—SECURE Command
•
Authorization and accessibility requirements
To resecure an object or file, you must be the generalized owner of the object or file.
You must also have read and write authority to the catalogs for the objects being
resecured. To alter the security attributes of a program file, you must also have read
authority to the program file.
All partitions, dependent indexes, and dependent protection views for tables being
changed must be accessible when SECURE executes.
•
Effect on related objects
Altering the security or ownership of an object can affect related objects. For more
information, see the ALTER commands for specific types of objects (ALTER
TABLE, ALTER VIEW, and so forth).
•
Transactions, breaks, and failures
ON Set the process accessor ID to the Guardian user ID of the owner of the program.
OFF Set the process accessor ID to the Guardian user ID of the user who runs the
process.