eels_db_admin [-tlevel]
-x perm get db [user [database]]
Description
Use eels_db_admin to add and delete databases,
purge records from a database, and get information
about tables and databases that exist in EELS.
Options
-tlevel
Print debugging information. Valid debugging levels are
``1'' for minimal logging to ``4'' for full logging.
-cdatabase table description creator
Create a database specifying values for the database name,
database table name, description and creator.
-ddatabase [table]
Delete a database or table. If it is a database that is to
be deleted no table name need be given.
NOTE:
Before you can delete a database, you must first delete any
tables contained in the database.
-pdatabase_table
Purge all records in the database table specified
in database_table.
-l [database]
List all configured EELS databases. If a
database name is specified, this command lists
the tables within that database.
-a
List all information about all configured EELS
databases, and the tables within those databases.
-xextended_command
Execute an extended command to modify the access privileges
of one or more users of the EELS database. The extended
commands are described in detail below.
Extended commands
The extended commands enable you to assign one
or more access privileges to an EELS user. The
privelleges you can assign using these commands are:
Abbreviation
Privilege
Description
S
Select Privilege
Grants the user permission to query records from the database table
using an SQL select string.
I
Insert Privilege
Grants the user permission to insert records into a database table.
P
Delete Privilege
Grants the user permission to delete records from a database table
via the SQL delete command. It also enables users to
delete records using the -p option of
eels_db_admin.
C
Create Privilege
Grants the user permission to create a table within a database.
D
Drop Privilege
Grants the user permission to delete database tables.
The extended commands are listed below:
perm add useruserperms
Grant the specified UNIX user the
global privileges listed in perms.
perm add dbuserdatabaseperms
Grant the specified UNIX user (UID) the privileges
listed in perms but only for the database named
in database.
perm delete useruser
Remove the specified UNIX user's global privileges.
perm delete dbuserdatabase
Remove the specified UNIX user's privileges for the
database name in database.
perm get useruser
List the specified UNIX user's global privileges. If
user is not specified, eels_db_admin
returns a list of all users and their global privileges.
perm get dbuserdatabase
List the specified UNIX user's privileges for the database named
in database. If user is not specified, eels_db_admin returns a list of all users and
their privileges for the specified database. If no
database is specified, eels_db_admin
returns a list of all the privileges the user has on all
the EELS databases currently in use.
NOTE:
Whenever you change the privileges of a user you must
restart EELS before the changes will take
effect.
Examples
The following example purges the contents of the ``events''
table in a database called ``httpd_db''.
eels_db_admin -p httpd_db events
The following example lists all configured EELS databases.
eels_db_admin -l
The resulting output from this command is shown below.