JDBC Users and Group ServicesΒΆ
We will now see how to add a new service using a database as a storage medium:
From the Welcome page click the Users, Groups, Roles link on the Menu Security section.
Note
You have to be logged in as Administrator in order to activate this function.
Click the Add new in the User Group Services menu
Click the JDBC link on top of the page
- Insert
jdbcservice
in theName
text field. - Select
Weak PBE
fromPassword encryption
combo box. - Select
default
fromPassword policy
combo box. - Select
org.postgresql.Driver
fromDriver class name
combo box. - Insert
jdbc:postgresql://localhost:5434/postgis20
in theConnection URL
text field. - Insert
postgres
in theUsername
text field. - Insert
postgres
in thePassword
text field. - Check the
Create database tables
checkbox
- Insert
Click the Save button.
Now we are going to add a user to the newly added user/group service:
From the Welcome page click the Users, Groups, Roles link on the Menu Security section
Click on the jdbcservice link
Click on the Users tab
Click on the Add new user button
- Insert
postgres
in theUser name
,Password
andConfirm Password
text fields. - Select the ROLE_ADMINISTRATOR element in the Available list of the Roles taken from active role service: default menu
- Click the arrow right button to add the element to the Selected list
- Insert
Click the Save button.
We will use this service in the JDBC Authentication section to create a new Authentication Provider.