Fujitsu UDS/SQL V2.5 사용자 설명서
Schema DDL
SCHEMA NAME and PRIVACY LOCK clause
U929-J-Z125-9-76
111
D
ok
us
c
h
abl
on
en
1
9x
24 V
e
rs
ion
7
.3
us
f
ü
r F
ram
eM
ak
er
V
7
.x
v
o
m
1
4.
02
.2
00
7
©
c
o
gni
tas
Gm
b
H
20
01-
20
07
24
. Ok
tobe
r 20
07
S
ta
nd
0
9:
30
.2
3
P
fa
d:
G
:\
v
og
t\
fs
c
\ud
s
\M
anu
al
e
\e
n\
ud
s
e
nt
_e\
u
ds
ent
.k
0
4
4.11 Assigning name and privacy to a schema
schema-name
[PRIVACY LOCK FOR COPY IS literal-1[ OR literal-2]].
[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.
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
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.
required.