GRANT EXECUTE statement

Grants a user privilege to execute a procedure or user-defined function.

Syntax

GRANT EXECUTE ON [ owner.]{ procedure-name | user-defined-function }
TO userid, ...

Remarks

None.

Privileges

You must own the procedure, or have the MANAGE ANY OBJECT PRIVILEGE system privilege.

Side effects

Automatic commit.

Standards

Example

The following example allows user SQLTester to execute the Calculate_Report procedure.

GRANT EXECUTE ON Calculate_Report
TO SQLTester;

The following SQL statement grants M_Haneef the privilege required to execute a procedure named my_procedure.

GRANT EXECUTE
ON my_procedure
TO M_Haneef;