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 the 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
default is WITH NO ADMIN OPTION.