CREATE PROCEDURE System Privilege

Required to create a self-owned stored procedure or function.

The CREATE PROCEDURE system privilege allows a user to:

  • Create self-owned stored procedures and functions
  • Issue COMMENT statement on self-owned procedures
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