Fujitsu UDS/SQL V2.5 Network Router User Manual


 
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\uds\Manuale\en\udsent_e\udsent.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 assigning of a
name to the schema.
schema-name specifies the name assigned to the schema 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.