A procedure is owned by the user who creates it or by the group or role specified in the CREATE PROCEDURE statement. A procedure can be executed by the owner and by any user, group, or role to whom the owner has granted execute permissions. Users, groups, and roles to which the owner has granted execute permission WITH GRANT OPTION can grant execute permission to other users.

Although a user can create a private procedure that accesses public tables, the user must have all required permissions on those tables to be able to execute the procedure.