Required to alter any table owned by anyone.
The ALTER DATABASE system privilege allows a user to:
- Issue ALTER or TRUNCATE statement on tables, table partitions, or views
owned by any user
- Issue COMMENT statement on tables owned by any user
- Issue 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 WITH NO ADMIN OPTION
clause is used by default.