Paul TBBle Hampson wrote: > Just to take a side-thought, does dtc really need root access > to MySQL? > > You can grant a user rights to create a database, and in fact > can limit the names of the databases they can create/manipulate > using something like: > > GRANT ALL PRIVILEGES ON `dbprefix%`.* TO [EMAIL PROTECTED] > IDENTIFIED BY 'password'; > > I'm assuming (I've not looked) that DTC keeps all its user's > databases seperate by prefixing with the siteID or something. > > So a master DTC user with priveliges on `dtc_%` and user > databases called `dtc_siteID_%`. > > Just a thought...
No, DTC needs to have the full root access as it needs to create database, and grant privileges, to it's users. There is no such prefix, and I don't think there would be someday. Thomas -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
