RESTRICT_SCHEMA Procedure

20.23 RESTRICT_SCHEMA Procedure

This procedure revokes the privilege to assign a schema to workspaces.

Syntax

APEX_INSTANCE_ADMIN.RESTRICT_SCHEMA (
    p_schema IN VARCHAR2 );

Parameter

Table 20-19 RESTRICT_SCHEMA Parameters

Parameter	Description
p_schema	The schema.

Example

This example revokes the privilege to assign schema HR to workspaces.

begin
    apex_instance_admin.restrict_schema(p_schema => 'HR');
    commit;
end;