Admin user login
Jedox comes with a predefined administrator user account under the username admin. The password of the admin user is secured and is communicated to customers prior to the onboarding process. The admin user is protected against deletion. The given user rights regulate access to cell data and to selected system operations.
Password policy
Currently, Jedox users are not automatically prompted to change their password.
By default, passwords must contain the following elements:- at least 10 characters
- at least one digit
- at least one of the symbols !@#$%^&*
- at least one uppercase or lowercase letter [A-Z] [a-z]
- cannot contain a period or space
The password pattern as a regular expression is:
(?=^.{10,}$)(?=.*\d)(?=.*[!@#$%^&*]+)(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$
Any attempt to change the password that does not match the defined pattern will result in an error displayed in the Change Password dialog. If the new password does not match the pattern, an error message (error code 1004) is returned.
To use the latest and most secure algorithm, passwords stored in older versions of Jedox must be changed once.
Note for Jedox Web users: in the Jedox Web connection dialog, mark the Use login credentials checkbox to use the assigned rights. Otherwise, Jedox Web will use the rights of the username entered for the connection. Access rights can be defined for connections in a similar way to other objects, on the Security dialog of a connection. For example, a connection that statically applies to a user with high-level access (e.g. for Jedox Integrator) can be set to be inaccessible to lower-level user groups. Unprotected connections can be used by any given Jedox user, such as in the OLAP-related dialogs (e.g. Paste View).
Password management
By default, the passwords for all users are encrypted and stored in the system database in the system cube #_USER_USER_PROPERTIES.
You cannot retrieve user passwords from the system database via the In-Memory DB API. The API calls that retrieve the cell value of the "password" element return an access right error for anyone making the call, regardless of the user rights.
Passwords cannot be changed through direct cell writeback. They can only be changed in Jedox Web, Excel Add-in, or by using the PHP API functions palo_change_user_password / palo_change_password or the OLAP script command CHANGE_PASSWORD. You can also change individual passwords with a Groovy Job in Integrator.
If you have forgotten your password, contact your Jedox administrator or Jedox Support to set a new one.
Note: in case the repetitive incorrect login attempts of a user have resulted in a waiting period, the admin can reset both the "waiting time counter", and "max failed login attempts" by resetting the user's password.
Updated May 12, 2025