Home » MYSQL » Access Control for MySQL Stored Programs and Views » Question
  1. Which privilege is enabled to create of alter a stored function?
    1. TOP
    3. SUPER
    4. PRIOR
    5. None of these
Correct Option: C

In order to create or alter a stored function, the SUPER privilege should be given in addition to the CREATE ROUTINE privilege that is normally required. Depending on the DEFINER value in the function definition SUPER might be required.

Your comments will be displayed only after manual approval.