SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—640322-001
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.
mxtool Utility on page 5-111 Performs FIXUP, GOAWAY, and comment: INFO or
VERIFY operations.
POPULATE INDEX Utility
on page 5-112
Loads indexes.
PURGEDATA Utility on
page 5-115
Purges data from tables, indexes, or partitions.
RECOVER Utility on
page 5-119
Determines the state of a failed utility operation and
restores recoverable objects.
UPGRADE Utility on
page 5-121
Transforms all metadata that is visible on the local
node from its existing version to the current schema
version for the MXV.
VERIFY Operation on
page 5-124
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.