mel list_php wrote:
Hi,
This may be a strange question, but I was wondering if it is possible
to have a user starting/stopping the mysql server who wouldn't have
access to the data.
To explain: I want to set up a server as user "Groupinstaller" for
example. This is a virtual user to allow other people of my group to
start/stop the server by becoming "Groupinstaller".
But I don't want this user to be able to see the different databases
of the different people, nor touch the data directory. For example, I
have a database called db1 and my coworker has a db called db2.
I am root of mysql, so I have access to all the databases, but he is
just a user with access to his db and not to mine. If no other
solution, I could eventually do with a read access, but I really don't
want to allow write.
I was thinking at replacing the typical "mysql" user by the
"Groupinstaller" one, but this user owns the data directory...
Does anybody know if it is possible, and how?
thanks,
melanie
_________________________________________________________________
The new MSN Search Toolbar now includes Desktop search!
http://toolbar.msn.co.uk/
Hi,
If you are using a *nix operating system, then consider using sometbing
like sudo or ssu to allow the other user access to the startup/shutdown
script only. sudo can be found at http://www.sudo.ws/sudo/ not sure
where ssu comes from though.
Regards
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
