Thanks for that heads up, and yes i could do that and probably should for this user anyway
But for the most part these users are also class givers and are spread out a lot,,,, sometimes traveling with their laptops sometimes working from home. sometimes lecturing where they dont have controll over the PC. So i'd really need to do something web based. On 10/14/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > 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:256819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
