Starting from 2022.2 version Jedox implemented password policy change. That means that users cannot have abc123 passwords. Something more sophisticated should be done. Therefor certain rules needs to be followed:

  • 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

Example: Q20J!b5ei0951

This policy can be changed if the company has different set of rules. in that case parameter password-pattern in palo.ini allows you to change the password settings concerning the password length and the password pattern/complexity. Any attempt to change the password that does not match the defined pattern will result in an error displayed in the Change Password dialog. The password pattern can be defined by the key password-pattern <regular_expression>. If the new password does not match the pattern, an error message (error code 1004) is returned. <according to KB>.

Password policy

if in any case you built up the ETL which automatically assign the passwords to newly created users, groovy should look something like this:

def user = API.getProperty(‘user’);

def generator = { String alphabet, int n ->
new Random().with {
(1..n).collect { alphabet[ nextInt( alphabet.length() ) ] }.join();}
def password = generator(((‘A’..’Z’)+(‘0’..’9′)).join(), 4 )+”!”+generator(((‘a’..’z’)+(‘0’..’9′)).join(), 4)+generator(((‘0’..’9′)+(‘0’..’9′)).join(), 4 );

IConnection con = OLAP.getConnection(“Jedox_System”);
con.changePassword(user, password);;

In this code we will have 12 characters and they should include small, capital letters, numbers and “!”. Of course you can edit the code to pick some other random symbol as well.

DISCLAIMER : don’t use abc123 password or the one from the example.

ETL with the groovy example can be downloaded here.