UNRESTRICT_SCHEMA Procedure

20.29 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

Table 20-25 RESTRICT_SCHEMA Parameters

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;