Siemens V 4.0 Manuel D’Utilisation

Page de 244
38
GINA V4.0 System Administrator Guide – September 2000
Customizing the database layout
4. Versioning of the database
A version line contains the following entries:
v |
indent
|
Only one version line is permitted per database.
ident
Version of the database schema (string with a maximum of 30 characters)
Mandatory entry
Example
v | 1.0 |
5. Access privileges for tables and identical views
A privilege line contains the following entries:
s |
ident | name | resource |
A number of definition lines of this type are permitted per class.
ident
Name of the class in the specialist model
Mandatory entry
name
Name of the user that is assigned the privilege defined in the
resource
col-
umn
Mandatory entry
resource
Mandatory entry in a definition line for privileges. It names the privilege
assigned to the user.
Value range:
INSERT
allows you to make an object persistent.
DELETE
allows you to delete a persistent object.
UPDATE
allows you to modify a persistent object.
SELECT
allows you to instance a persistent object.
Only privileges are permitted at table and view level and only those that do
not change the schema (
ALTER TABLE
,
 CREATE TABLE
).
If the
ident
class is a view class, only the privilege
SELECT
is permitted.
Only the
 CONNECT TO PUBLIC
privilege is generated at database level.