23 Mar
2002
23 Mar
'02
18:54
On Sat, Mar 23, 2002 at 05:50:20PM +0100, scc wrote:
Hi everyone. sorry, a bit OT but I'm away from the office and have gone blank. I need
1. to create a user clara who can only work on the database astro
GRANT SELECT,UPDATE,INSERT,DELETE ON astro.* TO clara IDENTIFIED BY 'pasword';
2. change an existing user dave to only work on the database astro
Remove any permisions that he has in the user table of the mysql database, and then set his permissions in the db table. HTH, -v -- Victor R. Cardona Powered by SuSE Linux 7.1 (i386) Professional GPG key ID E81B3A1C Key fingerprint = 0147 A234 99C3 F4C5 BC64 F501 654F DB49 E81B 3A1C