Securing Database

[spano]

hi, ive got this problem with security, ive setup sandbox to stop anyone stealing my datasources, but how do i stop them downloading the file and veiwing the contents, i know you can put a password on it but is there another way? also here is an example, if i had to put a password on what would i have to change in this code to allow it to connect correctly?
<cfquery name="techsup" datasource="db">
SELECT *
FROM tbladmins
WHERE status='open'
</cfquery>

 

[wantstolearncfm]

The setup for a DSN is where you add the password and user.
This is used in the coldfusion admin screen just login then when you make the new datasource enter the username and password for the database. This works best with MYSQL access seems to have issues
Sandboxing is one of the only ways to make your datasource secure so doing that has locked down attempts that way
All the best

 

[spano]

So if i went into coldfusion and edited the datasource to adda user and pass which corosponds to the database that would work?
thanks

 

[wantstolearncfm]

it should as i say i mainly work in MYSQL databases which are easier to secure otherwise decoys are good.