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 16-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;
Parent topic: APEX_INSTANCE_ADMIN