32.15 GRANT_EXTENSION_WORKSPACE Procedure

This procedure grants read access for a workspace to an extension workspace. Builder extension menu links of the extension workspace appear in the grantor workspace's extension menu.

Syntax

APEX_INSTANCE_ADMIN.GRANT_EXTENSION_WORKSPACE (
    p_from_workspace    IN  VARCHAR2,
    p_to_workspace      IN  VARCHAR2,
    p_read_access       IN  BOOLEAN  DEFAULT FALSE,
    p_menu_label        IN  VARCHAR2 DEFAULT NULL )

Parameters

Parameter	Description
p_from_workspace	Name of workspace granting access.
p_to_workspace	Name of extension workspace.
p_read_access	Default FALSE. If TRUE, the extension workspace has read access to the grantor's repository views.
p_menu_label	(Optional) Overwrite the extension menu parent label. Otherwise, shows the name of the extension workspace.

Example

The following example grants extension workspace EXTENSIONS read access to workspace MY_WORKSPACE and overwrites the extension menu parent label with "Tools."

BEGIN
    apex_instance_admin.grant_extension_workspace(
        p_from_workspace      => 'MY_WORKSPACE',
        p_to_workspace        => 'EXTENSIONS',
        p_read_access         => true,
        p_menu_label          => 'Tools' );
END;