Thanks for that, Tim > > In CFAdmin, when the database is registered, you give a username > > and password, and the only one which seems to work here is the > > root user and password (ie superuser) set in MySQL, which is fair > > enough if you want to grant all users on your site access to all > > db functions. But naturally, one doesn't want to do that. > > I'm not entirely clear what you're trying to do -- are you trying to > create separate MySQL users with limited permissions? If that's the > case then it certainly is possible, you just need to create the user and > assign the appropriate access rights to the database. I go one step > further and limit access via IP address. > > If you're trying to use different access permissions depending on which > user is logged in to the front end (CF) app then you're going to have to > set up multiple DSNs - one for each "security level".
This is what I was actually trying to acheive, but even after creating the required permissions for the other (limited) users in MySQL, I seem unable to create separate DSNs in CFAdmin - if I try to create others, using a different DSN, but the same database, I get bounced with a 'Is there really a server on 3306?' message. The permissions work. If I log into my MySQL GUI (I'm using SQLyog) with the 'webuser' and his password, I can't insert (as expected), but can select. > > Create the three users in MySQL with the appropriate access permissions, > then create three separate DSNs in the CFAdmin. Then you'll somehow > have to switch between DSNs depending on which user is required to > access the system. > > Tim. Cheers Terry -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
