Fujitsu UDS/SQL V2.5 사용자 설명서
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]]
[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.
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.
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.
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
the section
).