You can provide partial or broad access to page application directories if you have geographically dispersed developers or those with varying degrees of requirements. In this case, you should set up some security for your ColdFusion data sources.
Consider taking these steps:
Use the ColdFusion Settings page when configuring the data source to set up username and password restrictions. For details, see Select ColdFusion settings.
Use the ColdFusion Settings page to restrict access to SQL operations. For example, you can restrict operations such as deleting or inserting data into the data source.
Use a database system that supports security and create a user account that has access only to selected tables and operation. Then configure the data source for ColdFusion to use that account.
For comparison charts on securing ColdFusion resources, see the book Developing ColdFusion Applications.