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