SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-8
SECURE Command
If you do not specify a security string, the security of files and objects remains
unchanged.
ALLOWERRORS [ ON | OFF | num ]
specifies action when errors occur:
If you omit the ALLOWERRORS clause completely, the default is
ALLOWERRORS OFF. If you specify ALLOWERRORS but do not specify an
option, the default is ALLOWERRORS ON.
If a user-defined transaction that includes a SECURE operations is rolled back, the
SECURE operation is terminated regardless of the setting of ALLOWERRORS.
CLEARONPURGE [ ON | OFF ]
specifies whether to erase the contents of an object or file when the object or file is
purged from disk.
CLEARONPURGE does not apply to collations.
If you omit the CLEARONPURGE option, the file attribute is not changed.
CLEARONPURGE ON is the default if you specify CLEARONPURGE but omit ON
and OFF.
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. For more information about Guardian user IDs, see User IDs on
page S-12.
If you do not specify the OWNER option, the ownership of the object remains
unchanged.
ON Resecure all elements of the fileset list regardless of how many errors
are encountered.
OFF Stop the operation when an error occurs.
num Resecure files and objects until the number of errors is greater than num.
ON Physically delete the data from the disk by overwriting the file space with
binary zeros.
OFF Logically deallocate the disk space but do not physically destroy the
data.