When you click on the name of a database in the Database section, the Database configuration interface displays.
This interface has buttons to manage the database: Edit, Reinitialize, access to Permissions, Deactivate or Delete the database. More details are shown in Managing Databases.
Several subsections display information on the database. The parameter values indicated were defined when the database connection was created. Refer to Creating Databases for the details of each parameter. Some parameters can be modified directly in the section, others by clicking on Edit.
This subsection displays the name, Id (internal JMap identifier), a description, and the database owner.
This subsection displays the details of the connection pool. The parameters indicated are the following: Initial size, Maximum size, Pool usage, Pool usage peak, Connection timeout, and Connection wait timeout.
This subsection displays the details of the database connection. The parameters indicated are the following: Status, Database (indicates the type), Driver, Connection string, Username, Validation query, and Connection type.
This subsection shows all the resources using the data from the database. The information in this section is presented hierarchically and displays the spatial data sources as well as the projects with the layers, reports, and forms, all showing the attributes used. This can be useful to view the resources that would be affected by changes made to the database.
The Permissions button appears in the Databases section and is enabled when at least one database is selected. It is also displayed in the database configuration interface.
The Permissions section has two tabs: Permissions and Owners. Owners are the only ones who can manage administrative permissions for the database, manage the list of owners and delete it.
Available users and groups are configured in the JMap Server section of JMap Admin. Refer to the Users and Groups section for more information about managing users in JMap Server.
There are only administrator permissions for databases.
A list of users and groups with permissions appears in the Permissions tab. Click on to add new users or groups.
Access database
Allows an administrator to view detailed database information.
Administrate database
Allows an administrator to modify the database configuration.
Use SQL console
Allows to use the SQL console on the database. The SQL console allows you to view the database structure and run SQL queries against the database.