5 Database Utilities
User privileges
User capabilities which are not database specific are specified by user privileges. The following user privileges are available:
- DBA
- The user has server administration privileges
- CONNECT
- The user is allowed to connect the server. This is implied if a user has the DBA privilege.
- UADMIN
- The user is allowed to administrate user accounts
The UADMIN privilege is required to maintain database user.
Syntax:
GRANT {privilege [,privilege ...]}
TO {PUBLIC | "user" [,"user" ...]} ;
REVOKE {privilege [,privilege ...]}
FROM {PUBLIC | "user" [,"user" ...]} ;
Description:
The GRANT statement is used to add the specified privileges to the capabilities of the given users.
The REVOKE statement is used to remove the specified privileges from the capabilities of the given users.
When PUBLIC is specified instead of a user list, the statement applies to all users.
For example:
REVOKE CONNECT FROM PUBLIC;
GRANT CONNECT TO "mike","marc";
This will disallow all users besides mike and marc to connect the database server.
Eloquence Database Manual - 19 DEC 2002