JDBC Users and Group ServicesΒΆ

We will now see how to add a new service using a database as a storage medium:

  1. 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.

    ../_images/usergroup1.png

  2. Click the Add new in the User Group Services menu

  3. Click the JDBC link on top of the page

    • Insert jdbcservice in the Name text field.
    • Select Weak PBE from Password encryption combo box.
    • Select default from Password policy combo box.
    • Select org.postgresql.Driver from Driver class name combo box.
    • Insert jdbc:postgresql://localhost:5434/postgis20 in the Connection URL text field.
    • Insert postgres in the Username text field.
    • Insert postgres in the Password text field.
    • Check the Create database tables checkbox
    ../_images/usergroup6.png

  4. Click the Save button.

Now we are going to add a user to the newly added user/group service:

  1. From the Welcome page click the Users, Groups, Roles link on the Menu Security section

  2. Click on the jdbcservice link

  3. Click on the Users tab

  4. Click on the Add new user button

    • Insert postgres in the User name, Password and Confirm 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
    ../_images/usergroup8.png

  5. Click the Save button.

We will use this service in the JDBC Authentication section to create a new Authentication Provider.