> I want to have a page that displays all the various tables in > my clients database (sql2005) and allow them to create their > own reports. the person doing this is very good with access > and building reports and fairly good with a query builder so > i could do linked tables to access, but i dont want to give > them the option to Insert, Update or delete. Any CF options > or Thoughts?
If you can get them direct access to the database, you could create a user account with limited rights - in the case of SQL Server, that would be a user account with the database role "db_datareader" and no other rights (revoked from "public", for example). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
