UNRESTRICT_SCHEMA Procedure

32.37 UNRESTRICT_SCHEMA Procedure

This procedure re-grants the privilege to assign a schema to workspaces, if it has been revoked before.

Syntax

APEX_INSTANCE_ADMIN.UNRESTRICT_SCHEMA (
    p_schema IN VARCHAR2 )

Parameter

Parameter	Description
`p_schema`	The schema.

Example

This example re-grants the privilege to assign schema HR to workspaces.

BEGIN
    apex_instance_admin.unrestrict_schema(p_schema => 'HR');
    COMMIT;
END;