There are two roles in the cache database with a general access to the data: CacheAdmin (for the administration and transfer of the data) and CacheUser (with read only access). The data in the cache databases are organized in projects. Therefore for every project you find one additional role: CacheAdmin_Project_... with the right to transfer of the corresponding project to the SQL-Server cache database. You find the project specific roles in the SQL-Server cache database, in the Postgres database only CachAdmin and CacheUser are available.
To administrate the logins in the
SQL-Server database, go to
the
Update and Sources tab and click on the
button of the cache database to
open a window as shown below. To administrate the access for other logins, you have
to be a System administator. For further details please see the
chapter about the login administration for the main database.
To view the access rights of a selected role click on
the
button to open a window as
shown below.
To handle the logins and user groups on the Postgres database
server, go to the
Update and Sources tab and click on the
button of the postgres
database. A window as shown below will open, where you can create
and delete logins and groups. For the logins you can change their membership in
groups and their properties (see below). On the left you find 2 lists, with the
upper list containing the logins and the list below with the groups resp. roles.
For the logins you can set the general properties as shown below. The login postgres
is created with the installation of the database and is the login for the administration
of the database including the updates etc. For details about predefined properties
like "Is superuser", please turn to the Postgres documentation.
In the Membership in groups area you can define the groups in which the login is a member (see below).
For the groups you can change their membership in other groups and their permissions (see below).
