Oracle XML Schema Repository Level
The Oracle database supports XML schema repository (XSR) in the database catalogs. The
contextual menu of a XML Schema Repository node in the tree from the
Data Source Explorer view contains the following actions:
- Performs a refresh for the sub-tree of the selected node.
- Opens a dialog box 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 is 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 user database schemas.