CREATE ANY TABLE System Privilege

Required to create tables owned by any user.

The CREATE ANY TABLE system privilege allows a user to:

  • Create tables, including proxy tables, 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.
Related reference
List All System Privileges