ADD_SCHEMA Procedure

32.3 ADD_SCHEMA Procedure

This procedure adds a schema to a workspace to schema mapping.

Syntax

APEX_INSTANCE_ADMIN.ADD_SCHEMA (
    p_workspace             IN VARCHAR2,
    p_schema                IN VARCHAR2,
    p_grant_apex_privileges IN VARCHAR2 DEFAULT FALSE )

Parameters

Parameter	Description
`p_workspace`	The name of the workspace to which the schema mapping is added.
`p_schema`	The schema to add to the schema to workspace mapping.
`p_grant_apex_privileges`	Grant the privileges needed by Oracle APEX to this schema. Default `FALSE`.

Example

The following example demonstrates how to use the ADD_SCHEMA procedure to map a schema mapped to a workspace.

BEGIN
    APEX_INSTANCE_ADMIN.ADD_SCHEMA('MY_WORKSPACE','FRANK',true );
END;

Parent topic: APEX_INSTANCE_ADMIN