5 Database Utilities

Managing database users

The UADMIN privilege is required to maintain database user.

Creating a database user

CREATE USER "user" [ PASSWORD "password" ];

Create a new database user. When a password is present, it will be associated with the user. The password is case sensitive. Please note, that a user must be granted the connect privilege in order to connect the server.

For example:

   CREATE USER "mike" PASSWORD "secret":

Deleting database user

DROP USER "user" [,"user2" ...];
Remove the specified user from the database server.

For example:

   DROP USER "mike","marc":
This will remove the users "mike" and "marc".

Changing user password

ALTER PASSWORD FOR USER "user" TO "password";
Change the password for the specified user. Passwords are case sensitive

For example:

   ALTER PASSWORD FOR USER "mike" TO "secret":
Eloquence Database Manual - 19 DEC 2002