RESTRICT_SCHEMA Procedure

32.29 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

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;