The Oracle database supports XML schema repository (XSR) in the database catalogs. The
contextual menu of a
XML Schema Repository node of
the tree from the Data Source Explorer view contains the following
- Refresh - Performs a refresh
of the selected node's subtree.
- Register - Opens a dialog for adding a new schema file in the XML
repository. To add an XML Schema, enter the schema URI and location on your file system.
Local scope means that the schema will be visible only to the user who registers it. Global
scope means that the schema is public.
Registering a schema may involve
dropping/creating types. Hence you need type-related privileges such as DROP TYPE, CREATE
TYPE, and ALTER TYPE. You need privileges to delete and register the XML schemas involved
in the registering process. You need all privileges on XMLType tables that conform to the
registered schemas. For XMLType columns, the ALTER TABLE privilege is needed on
corresponding tables. If there are schema-based XMLType tables or columns in other
database schemas, you need privileges such as the following:
- CREATE ANY TABLE
CREATE ANY INDEX
SELECT ANY TABLE
UPDATE ANY TABLE
INSERT ANY TABLE
DELETE ANY TABLE
DROP ANY TABLE
ALTER ANY TABLE
DROP ANY INDEX
To avoid having to grant all these privileges to the schema owner, Oracle recommends
that the registration be performed by a DBA if there are XML schema-based XMLType table or
columns in other users' database schemas.