MPX_GLOBAL_TABLE_PRIV option

Function

Lets a query server grant and revoke permissions on objects created by the write server.

Allowed values

ON, OFF

Scope

DBA permissions are required to set this option. Can be set only for the PUBLIC group. Takes effect immediately.

Default

OFF

Description

To enable this option, set it ON. Setting MPX_GLOBAL_TABLE_PRIV ON allows grant and revoke of table and execute permissions of write server objects on a query server.

See also

“MPX_LOCAL_SPEC_PRIV option”.