Required to alter any table owned by anyone.
The ALTER DATABASE system privilege allows a user to:
- Issue ALTER or TRUNCATE statements on tables, table
partitions, or views owned by any user
- Issue the COMMENT statement on tables owned by any user
- Issue the COMMENT statement on columns on tables owned by
any user
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.