Filter
Top Products
Subschema DDL User interface
184 U929-J-Z125-9-76
6.1.2 Assigning name and privacy to a subschema
SUB-SCHEMA NAME IS subschema-name OF SCHEMA NAME schema-name
[PRIVACY LOCK FOR COMPILE IS literal-1[ OR literal-2]]
subschema-name specifies the name of the subschema and is assigned by the user. Within
one DB configuration, subschema-name must be unique in the first 6 characters.
schema-name specifies the schema from which the subschema is derived.
Access to the data in a database by means of a subschema is dependent on a user’s
access rights. Data protection can be enhanced by the assignment of passwords.
With literal-1 and literal-2, the user can assign passwords that prevent the unauthorized
compilation of a DML program by means of this subschema. Compilation is only possible if
at least one password is known.
6.1.3 Unlocking a schema for creating a subschema
PRIVACY KEY FOR COPY IS literal.
If a schema has been provided with password protection to prevent the unauthorized
creation of a subschema, users must prove their access authorization.
For literal, the user must specify one of the passwords defined to protect the schema (see
the section “Assigning name and privacy to a schema” on page 111).