How about myLittleAdmin. Russ
-----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: 15 October 2006 17:44 To: CF-Talk Subject: Re: Reports and Creative Clients 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:256826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
