Oracle Maestro online help
Prev | Return to chapter overview | Next |
Specifying procedure options
Specify procedure options according to your needs. The detailed description is given below.
Name
The new procedure name as it was set on the previous step.
Owner
Defines the owner for the procedure.
Invoker rights (DEFINER, CURRENT USER)
Specify DEFINER to indicate that the procedure executes with the privileges of the owner of the schema in which the procedure resides, and that external names resolve in the schema where the procedure resides. Specify CURRENT USER to indicate that the procedure executes with the privileges of CURRENT USER. This clause also specifies that external names in queries, DML operations, and dynamic SQL statements resolve in the schema of CURRENT USER. External names in all other statements resolve in the schema in which the procedure resides.
Prev | Return to chapter overview | Next |