next up previous contents
Next: Granting access rights to Up: Defining users Previous: Registering user on the   Contents


Registering user on the APIIS system level

General APIIS account which is created on this level is required to work with the APIIS System. On the basis of this account the access rights for the user are created and then checked. The data about user are stored in the database (see section 1.13, figure 1.5: AR_Users). The following information about each user is collected:

As an example of the user data, you can see Table 1.1.


Table 1.1: Users table
user_id login password db_unit country language marker 1

disables status last_login last_activ_time NO


The APIIS system is based on the PostgreSQL database and to work with it user needs also database account. PostgreSQL account is created automatically during the creation of APIIS account. The login and the password are exactly the same like these defined for the APIIS account. This database account is needed for log-in to the system and also to give user the possibility of executing SQL SELECTs. These SELECT statements are executed on the views1.5 which are created in the user schema on the basis of user access rights. The actions like insert, update, delete are effected by the meta_user (1.3.3). The meta_user is responsible for all modifications in the database and nobody else can do this. When the user executes a DML, the connection to the database is established from the meta_user. Real user name is used to check user access rights. Then the meta_user run all processes if the user has authorisation for this action. Real user name is sent as a normal data for the meta fields (last_change_user).
All other actions like creating, dropping and altering some objects are revoked from the user (even after log-in in to database from the command line). The user can not also create new users and databases.


next up previous contents
Next: Granting access rights to Up: Defining users Previous: Registering user on the   Contents
Marek Imialek 2006-06-22