Granting Stored Command Privileges |
By default only the owner of a stored command or a user with DBA authority or higher have the execute privilege for the stored command. The owner or a user with DBA authority or higher may grant execute privilege to allow the stored command to be called by other users. The execute privilege can also be revoked from other users with resource authority by the owner of the stored command. A user with authority or higher has all privileges on all stored commands and can revoke those privileges even from the owner of the stored command (unless the owner has DBA authority or higher).
Related topic: