Starting with version 12.6 ESD 3, Sybase IQ restricts certain permissions by default. For details, see “Multiplex permissions overview” in Chapter 12, “Managing User IDs and Permissions” in the Sybase IQ System Administration Guide.
Prior to ESD 3, Sybase IQ allowed query servers to create and drop users, groups, and group memberships and to change permissions on objects created by write servers. This caused conflicts with permissions set by write servers.
The database options MPX_GLOBAL_TABLE_PRIV and MPX_LOCAL_SPEC_PRIV let you override the permission restrictions. For details, see “MPX_GLOBAL_TABLE_PRIV option” and “MPX_LOCAL_SPEC_PRIV option” in Sybase IQ Reference Manual.
