SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-2
Privileges Required to Execute Utilities
Privileges Required to Execute Utilities
For utilities that require a super ID, the use of user aliases is permitted.
PURGEDATA Utility on
page 5-76
Purges data from tables, indexes, or partitions.
RECOVER Utility on
page 5-80
Determines the state of a failed utility operation and
restores recoverable objects.
VERIFY Operation on
page 5-82
Reports whether SQL/MX objects and programs are
consistently described in file labels, resource forks,
and metadata.
Utility Privileges Required
BACKUP Be the schema owner.
DUP Have SELECT privilege on the source table and be the owner of
the schema where the target table will reside.
FIXUP operation Be the super ID.
GOAWAY operation Be the super ID.
import Have ALL privileges.
INFO operation Have any privilege level
migrate Be the super ID.
MODIFY Be the schema owner.
mxexportddl Be the super ID.
MXGNAMES Have READ/WRITE access to the Guardian subvolume where
you are executing MXGNAMES.
POPULATE INDEX Have ALL privileges.
PURGEDATA Have ALL privileges.
RECOVER Have the privileges required for the utility being recovered.
RESTORE Be the schema owner.
VERIFY operation Have SELECT privilege on all columns of the table.