> 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". 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. -- ------------------------------------------------------- Badpen Tech - CF and web-tech: http://tech.badpen.com/ ------------------------------------------------------- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- -- 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]
