5 Database Utilities

Managing database groups

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 database context must be defined before managing database groups. The DBPRIV privilege is required to maintain database groups.

Creating a database group

CREATE GROUP "group";

Create a new database access group.

For example:

   CREATE GROUP "users";

Deleting database groups

DROP GROUP "group" [,"group2" ...];
Remove the specified groups from the database.

For example:

   DROP GROUP "users";
This removes the group "users".

Eloquence Database Manual - 19 DEC 2002