Role restriction

Some statements are restricted to nodes of certain roles:

Table 3-2 lists statements with role restrictions. Unlisted statements are unrestricted.

Table 3-2: Role restricted commands

Coordinator role restriction

Writer role restriction

  • All CREATE/ALTER/DROP DBSPACE commands operating on IQ main store dbspaces

  • BACKUP DATABASE

  • LOCK TABLE

  • sp_iqemptyfile

All DDL commands that affect objects in the IQ main store dbspaces. This includes ALTER/DROP of:

  • Tables

  • Single and multicolumn indexes

  • Table constraints