AnsweredAssumed Answered

AFX - Password Reset on Oracle Database

Question asked by Pradeep Kadambar Employee on Jul 26, 2017
Latest reply on Jul 29, 2017 by Pradeep Kadambar

I am working on reset password functionality + password sync for Oracle 10g/11g and facing issue in AFX.


Crux of the problem is that Oracle 10g/11g does not accept identifiers longer than 30 characters and our OOB reset password encrypts the password. As a result Oracle refuses to alter user.


        <Request timestamp="2017-07-26T11:13:44.177-04:00" id="1">
            <verb name="ResetPassword">
                    <parameter name="Password">ENCAKAx(KrY9TBZf5z+ePVyhQX+y/9LJvq4q9v2RZVc6ENA8PS23EPNVI0RfLQ==)</parameter>
                    <parameter name="Account">CUR32495</parameter>
            <Response timestamp="2017-07-26T11:13:50.045-04:00">
                    <brief>java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option
java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option

The AFX has the verb


ALTER USER ${Account} IDENTIFIED BY ${Password}

Is there a way around using reset functionality without encrypting the password ?