Dan,
This script can be scheduled, is does require the CF admin password to be used,
hardcoded here. This one uses JDBC Oracle connection.
<cfscript>
adminObj = createObject("component","cfide.adminapi.administrator");
adminObj.login("adminpassword");
myObj = createObject("component","cfide.adminapi.datasource");
myObj.setOther(driver="oracle jdbc",
name="dsnname",
url="jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=hostname)(port=1521))(connect_data=(sid=oraclesid)))",
class="oracle.jdbc.driver.OracleDriver",
username = "username",
password="newpassword");
</cfscript>
> We're looking for a way to automate our data source password changes.
>
> Does anyone know of a way to to change the passwords without logging
> into the CF Administrator? We are on MX 6.1 and use Oracle data
> sources.
>
> Has anyone used datasource.cfc in MX7 to automate their password
changes?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255987
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
