Schema DDL SCHEMA NAME and PRIVACY LOCK clause
U929-J-Z125-9-76 111
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 24. Oktober 2007 Stand 09:30.23 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k04
4.11 Assigning name and privacy to a schema schema-name
[PRIVACY LOCK FOR COPY IS literal-1[ OR literal-2]].
The definition of a database with the schema DDL always begins with the assig ning of a
name to the schema.
schema-name specifies the name assigned to the schem a by the user. This name is later
referenced by the SSL, the subschema DDL and the utility routines.
How the data in the database can be accessed by means of the subschema depends on
the individual user’s access rights.
literal-1 and literal-2 specify passwords which prevent the creation of unauthorized
subschemas. In order to create a subschema, knowledge of at least one password is
required.