Any idea, on how to enforce password change upon next login during Account creation using Oracle Database Connector ? Any additional flag or attribute that can be sent via Oracle Database Connector ?
Hello @cgurung
As per my understanding, Orcale does not have built-in flag in the connector for password change in next login. It can be implemented via after provisioning rule.
For Example:
if (AccountRequest.getOperation().equals(AccountRequest.Operation.Create))
{
String sql = “ALTER USER” + username + “PASSWORD EXPIRE”;
}
First we need to expire the password right after creating the account then Oracle will automatically ask the user the set a new password when they login for fist time.
Hi @Chhiting,
If you have a requirement to have password to change upon next login I would recommend impleted the JDBC connector which will give you flexibility to do changes in the JDBCProvision Rule. We dont have much customization to do in Oracle Database Connector.
Let me know if you need the code for JDBCPRovision that should be easy to implement
Hi @cgurung
I agree with @Pankaj_IAM_SailPoint
Oracle connector doesn’t support a direct option change password,you can handle this using a Before/After Provisioning Rule by executing Sql query
ALTER USER < username> PASSWORD EXPIRE
after account creation.this will make the user to change the password on first login.