SPACE ADMIN authority is the permission to manage dbspaces.
SPACE ADMIN authority is required to:
Create, alter, drop or comment on dbspaces.
Grant or revoke CREATE permission on dbspaces.
Move data and metadata to dbspaces.
Perform read-only selective restore operations. See “Before you restore”.
SPACE ADMIN authority can create a dbspace; however
to create objects in the dbspace, a user must be granted CREATE
permission on the dbspace. A user who has both SPACE ADMIN and RESOURCE
authority must still be granted CREATE privilege on that dbspace
to create objects in that dbspace. Without CREATE privilege, attempts
to create objects return Permission Denied errors.
To add CREATE privilege, use GRANT CREATE ON.
Only a user with DBA or PERMS ADMIN authority may grant SPACE ADMIN authority to other users.
