SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-3
Privileges Required to Execute Utilities
Privileges Required to Execute Utilities
For utilities that require a Super ID, the use of Super ID aliases is permitted.
Utility Privileges Required
CLEANUP Object owner or Super ID if the operation is by ANSI name.
If the -oo option is specified, Super ID is required.
DOWNGRADE Super ID.
DUP SELECT privilege on the source table.
Be the owner of the schema where the target table resides.
FASTCOPY SELECT privilege on the source table.
SELECT, INSERT, UPDATE and DELETE privilege on the target
table
FIXUP operation Super ID.
GIVE SCHEMA Schema owner or a security administrator.
GOAWAY operation Super ID.
import Have ALL privileges.
INFO operation Any privilege level.
MODIFY Schema owner or object owner or super ID.
mxexportddl Super ID.
mximportddl 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 corresponding utility privileges for the utility to be
recovered.
RECOVER SCHEMA Schema owner or the security administrator.
UPGRADE Super ID.
VERIFY operation SELECT privilege on all columns of the table.