Privileges Required to Manage Table Objects in a Dbspace

There are specific system privileges required to create or move a table object in a dbspace.

Requires the CREATE privilege on the dbspace. The CREATE privilege in a dbspace can be granted to or revoked from a user or a role. Any member in a role inherits CREATE privilege from the role. By default, CREATE privilege on IQ_SYSTEM_MAIN, IQ_SYSTEM_TEMP, and SYSTEM is granted to PUBLIC. For other IQ main dbspaces, the system administrator must explicitly grant CREATE privilege on the dbspace before a role or user can create or move objects into that dbspace. For example, if a table is to be placed on a new IQ main dbspace, the user must have CREATE privilege on that dbspace. Users must also have CREATE ANY OBJECT privilege to create objects.