To create a table object in a dbspace or to move a table object to a new dbspace requires CREATE permission in the dbspace. The CREATE permission in a dbspace can be granted or revoked for a user or group. Any member in a group inherits CREATE permission from the group. By default, the CREATE permission 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 permission on the dbspace to a group/user before they can create or move objects into that dbspace.
