Required to perform management-related tasks on dbspaces.
The MANAGE ANY DBSPACE system privilege allows a user to:
- Issue CREATE, ALTER, DROP, or COMMENT statements on any
dbspace
- GRANT or REVOKE the CREATE object-level privilege on any dbspace
- Move data to any dbspace
- Issue a read-only selective restore statement on any dbspace
- Run the database delete file function
Grant this system privilege using the WITH ADMIN OPTION, WITH NO
ADMIN OPTION, or WITH ADMIN ONLY OPTION clause. If you do not specify a clause, the
default is WITH NO ADMIN OPTION.