Granting access

E Obsolete Database Utilities

Granting access

GRANT privilege ACCESS
  ON target_list
  TO acl_list;

Where privilege is one of:

READ: Allow read access
WRITE: Allow read and write access
ALL: Same as WRITE

The target_list is either ALL or a list of data set identifiers separated by a comma (,). If ALL is specified, the privilege will be granted to all data sets.

The acl_list is a list of access profile numbers separated by a comma (,). The keyword PUBLIC may be used as a synonym for access class 0.

For example:

   GRANT READ ACCESS
   ON Customers,Parts,Orders,Order-Entries
   TO PUBLIC;

This will allow read access to the data sets Customers,Parts,Orders and Order-Entries to everyone.

   GRANT WRITE ACCESS
   ON Customers,Parts,Orders,Order-Entries
   TO 1,2,3;

Write access to the given sets is enabled for members of the access class 1, 2 or 3.

Eloquence Database Manual - 19 DEC 2002