5 Database Utilities

Associating users with a group

The Eloquence database uses groups to manage database specific privileges. When a user is associated with a group, it will gain all capabilities granted to the group. A user can be a member of up to 8 groups per database.

A database context must be defined before managing database groups. The DBPRIV privilege is required to maintain database groups.

Syntax:

GRANT {"group" [,"group" ...]}
TO {PUBLIC | "user" [,"user" ...]} ;

REVOKE {"group" [,"group" ...]}
FROM {PUBLIC | "user" [,"user" ...]} ;

Description:

The GRANT statement is used to associate the specified users to the given groups.

The REVOKE statement is used to disassociate the specified users from the given groups.

When PUBLIC is specified instead of a user list, the statement applies to all users.

For example:

   GRANT "users" TO "mike",marc";
This will make the users mike and marc members of the group "users".

Eloquence Database Manual - 19 DEC 2002