At 06:31 PM 1/23/2003 -0800, you wrote: >At 08:11 PM 1/23/03 +0100, you wrote: > > >>- you could use multiple logins to the database, a readonly login and a > > normal > > >>one for instance > > > > > > Tell me more. > > > >Define more as 1 login. Use the readonly login from all the public > >templates, and the one with full access from an administrative interface. > >I cannot find a reference on this for SQL7. All read only references I see >refer to read-only-ing the database with no reference to how a database >could be read-only for one login and not read-only for another login.
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). Use each DS appropriately in your app and you'll be fine. I would reccomend both creating two users in the database with appropriate permissions in addition to using two CF datasources. The more layers of security the better. Andrew Golden ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
