Privileges for Registering a Routine

To register a routine in the database, an authorized user wraps the SPL commands in a CREATE FUNCTION or CREATE PROCEDURE statement. The database server stores a registered SPL routine internally. The following users qualify to register a new routine in the database:

• Any user with the DBA privilege can register a routine with or without the DBA keyword in the CREATE statement.

  For an explanation of the DBA keyword, see DBA Privileges for Executing a Routine.

• A user who does not have the DBA privilege needs the Resource privilege to register an SPL routine. The creator is the owner of the routine.

  A user who does not have the DBA privilege cannot use the DBA keyword to register the routine.

  A DBA must give other users the Resource privilege needed to create routines. The DBA can also revoke the Resource privilege, preventing the user from creating further routines.

A DBA and the routine owner can cancel the registration with the DROP FUNCTION or DROP PROCEDURE statement.