SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-7
SECURE Command

This example searches for values where supplier number in the SUPPLIER table
equals supplier number in the PARTSUPP table, and part number is less than
3000 or equal to 7102:
SUPPLIER.SUPPNUM = PARTSUPP.SUPPNUM
AND (PARTNUM < 3000 OR PARTNUM = 7102)
SECURE Command
SECURE is an SQLCI utility that changes security, ownership, and some file attributes
for tables, views, collations, SQL programs in Guardian files, and Enscribe files.
SECURE does not change the security or ownership of catalogs, catalog tables, or
SQL programs in OSS files.
qualified-fileset-list
is a qualified fileset list that specifies the SQL objects, SQL programs in Guardian
files, and Enscribe files for which to change security or ownership. For information,
see Qualified Fileset List
on page Q-1.
SECURE changes the security you specify for a table or protection view before it
changes the ownership. SECURE changes the security of objects, programs, and
files in the order in which you specify them.
To change the security of a partitioned Enscribe file, you must specify the primary
partition in qualified-fileset-list. SECURE then changes the security for
all partitions.
If SMF is installed on your node, qualified-fileset-list cannot specify any
file or object on a $*.ZYS*. subvolume.
"rwep"
is a four-character string that specifies the new Guardian security for the objects
and files. For more information, see Security on page S-11.
Make sure the security you specify for an SQL object includes read access for
users who have write access.
SECURE qualified-fileset-list [ [,] option ] ... ;
option is:
{ "rwep" }
{ ALLOWERRORS [ ON | OFF | num ] }
{ CLEARONPURGE [ ON | OFF ] }
{ OWNER { group-name.user-name } }
{ { group-number, user-number } }
{ PROGID [ ON | OFF ] }
{ [ NO ] LISTALL }