62 DBMS_EDITIONS_UTILITIES

The DBMS_EDITIONS_UTILITIES package implements the Edition API which provides helper functions for edition-related operations.

The chapter contains the following topics:

Using DBMS_EDITIONS_UTILITIES
- Overview
- Security Model
- Exceptions
Summary of DBMS_EDITIONS_UTILITIES Subprograms

ARPLS73499

ARPLS73500

Overview

The DBMS_EDITIONS_UTILITIES package implements the Edition API which provides helper functions for edition-related operations.

ARPLS73501

Security Model

This package is owned by SYS with execute access granted to PUBLIC. It runs with invokers rights, that is, with the security profile of the caller.

ARPLS73502

Exceptions

ARPLS73503 Table 62-1 DBMS_EDITIONS_UTILITIES Error Messages

Error	Description
`ORA-38817`	Insufficient privileges
`ORA-942`	Missing table

ARPLS73504

Summary of DBMS_EDITIONS_UTILITIES Subprograms

ARPLS73505 Table 62-2 DBMS_EDITIONS_UTILITIES Package Subprograms

Subprogram	Description
SET_EDITIONING_VIEWS_READ_ONLY Procedure	Given the schema name and table name, this procedure sets the corresponding editioning views in all editions to `READ` `ONLY` or `READ/WRITE`

ARPLS73506

SET_EDITIONING_VIEWS_READ_ONLY Procedure

Given the schema name and table name, this procedure sets the corresponding editioning views in all editions to READ ONLY or READ/WRITE.

Syntax

DBMS_EDITIONS_UTILITIES.SET_EDITIONING_VIEWS_READ_ONLY (
   table_name IN VARCHAR2,
   owner      IN VARCHAR2 DEFAULT NULL,
   read_only  IN BOOLEAN  DEFAULT TRUE);

Parameters

ARPLS73507 Table 62-3 SET_EDITIONING_VIEWS_READ_ONLY Procedure Parameters

Parameter	Description
`table_name`	Base table of the editioning views
`owner`	Base table schema. The default (or `NULL`) is the current schema.
`read_only`	`TRUE` to set the views to read-only; `FALSE` (or `NULL`) sets the views to `READ/WRITE`. Default is `TRUE`.

Usage Notes

The user must have the following privileges:

Owner of the table, or have the ALTER ANY TABLE system privileges
USE object privilege on all the editions for which the views are defined