Note that username needs to match in these two tables. Passwords should be encrypted in the database table.
For more information see http://www.eclipse.org/jetty/documentation/current/configuring-security-secure-passwords.html
Note! oskari_users can store users that don't have credentials in oskari_jaas_users for example when using the SAML-login users are
stored without credentials. This way users will have an internal id/uuid that can be used to link user content.

oskari_jaas_users is used for database based authentication only.

2. Adding new roles

Add a role to oskari_roles table:

INSERT INTO oskari_roles(name) VALUES('MyRole');

3. Map users to roles

Add mapping to oskari_role_oskari_user table:

INSERT INTO oskari_role_oskari_user(user_name, role_id) VALUES('username', (SELECT id FROM oskari_roles WHERE name = 'MyRole'));