Hi everyone,
I have this situation: I create Accounts through a custom task and provision them to LDAP (Red Hat Directory).
The Password is sent via email to the Account in order to change it at the first login in IGL.
I'm using a SQL node to generate a random password but is not matching the password policy defined.
Is there another way to generate a random password matching the policy?
I'm using RSA IGL 7.1.1
Thank you,
Marta
Hi Marta,
Can you share the SQL you are using to generate the password at present please?
I'm using this:
select
TRUNC(DBMS_RANDOM.VALUE(1,999))
|| DBMS_RANDOM.STRING('u',2)
|| '!'
|| DBMS_RANDOM.STRING('l',2)
as TMP_PASSWORD
FROM dual;But I'd like to use a random special char, not a fixed one.
Marta
What if you pick a character randomly with substr from a string which contains all of your special characters?
I mean instead of '!' you should use SUBSTR('!%+?_=', DBMS_RANDOM.VALUE(1,6), 1) or something like this.
Actually it's a very good idea, it didn't occur to me.
It's working fine and also the policy is matched, thank you a lot
As a general comment, your creation of accounts in custom tasks points towards a serious design smell.
What if you pick a character randomly with substr from a string which contains all of your special characters?
I mean instead of '!' you should use SUBSTR('!%+?_=', DBMS_RANDOM.VALUE(1,6), 1) or something like this.