ColdFusion: getting ORA-28000: account is locked when cfschedule starts

Question

I have a simple cfschedule task that uses check_settings.cfm. Check_settings parameters have the following content

<cftry>
<cfquery name="get_settings" datasource="#request.dsn#">
    select id, setting_value
    from tbl_appsettings
    where scope = 'A'
    and active = 1
</cfquery>
<cfcatch type="any">
    <cfmail from="[e-mail]"
            to="[e-mail]"
            subject="Settings check"
            type="html">
            We have encountered a problem.<br />
            cfcatch.Message = #cfcatch.Message#<br />
            cfcatch.Detail = #cfcatch.Detail#<br />
            The program has been aborted.
    </cfmail>
    <cfabort>
</cfcatch>

The task is assigned monthly, but when it was last run, it generated an error:

cfcatch.Message = Error querying database. cfcatch.Detail = [Macromedia] [Oracle JDBC Driver] [Oracle] ORA-28000: Account is locked.

Can this be caused by the expired db password in the DSN settings. I know that our web administrator changes the password every 3 months due to some security policy. Could this be the reason?

Answer 1

, , , , - . , - ColdFusion DSN. ( , -, ), .

, . , - , .

, . , 10 Oracle.

, , , , - .