USER IDs


ORACLE controls access to the database with user IDs which have associated
passwords. Different users can GRANT read or write access (SELECT/UPDATE) to
the tables that they own.

Nearly all of the tables concerned with experiment communication are owned
by LEPMEAS. 

User ids (L3, ALEPH, OPAL and DELPHI) have been created for use by the experiments.
LEPMEAS has granted select and update access to it's tables as appropriate.
( N.B. The experiments' user ids do not have the right to create tables. )

The individual experiments should use their own user id to access lepmeas's tables.

To find out which tables one has access to one issues the command:

SELECT TABLE_NAME FROM ALL_TABLES;

(SELECT TABLE_NAME FROM TABS OR SELECT TABLE_NAME FROM USER_TABLES only gives
those tables which the user actually owns.)

To find out which VIEWS one has access to one issues the command:

SELECT VIEW_NAME FROM ALL_VIEWS;

To access lepmeas tables one must prefix the appropriate table name by 'lepmeas'
as an identifier.

For example to access the table M_L3_LUMI issue:

SELECT * FROM LEPMEAS.M_L3_LUMI;    (SQL is not case sensitive, by the way.)





Mike Lamont 4/3/96