Table space privileges

The table space privileges involve actions on the table spaces in a database. A user can be granted the USE privilege for a table space, which then allows them to create tables within the table space.

The owner of the table space is granted USE privilege with the WITH GRANT OPTION on the table space when it is created. Also, users who hold SECADM or ACCESSCTRL authority have the ability to grant USE privilege on the table space.

Users who hold SYSADM or SYSCTRL authority are able to use any table space.

Upon creating a non-restrictive database, by default, the USE privilege for the table space USERSPACE1 is granted to PUBLIC. This privilege can be later revoked.

You cannot GRANT the USE privilege to SYSCATSPACE and any other system temporary table spaces.