Which privilege required create procedure/function

Help Security
1

Please let me know which privilege is required to create stored procedure/function.

2

Hello rjsv,

You need following grants to create procedure.

GRANT CREATE ROUTINE,ALTER ROUTINE,EXECUTE on <DATABASE_NAME>.* TO ROLE ‘<ROLE_NAME>’;

3

Thank you very much for your prompt response.