Andrew Golden wrote: > > You should be able to assign permissions on a per user basis in SQL 7 or if > you want to back the restrictions out from the database itself go into > cf-admin's datasources management interface and create two datasources, one > for reading and one for writing and then select the appropriate SQL > function available to each (i.e. only allow SELECTS on one).
I would not rely on the functionality of CF MX to provide this kind of security. In combination with various database escape characters it is rather easy to circumvent. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
