Hello,
I need to create a user ('x', for instance) that only has permission to
access (Select, insert, update, delete) only 2 tables in a database
('test').
Assuming that 'x' does not exist, I execute the folowing statments ('a' and
'b' are the tables whose access I want to grant to 'x'), connected as
'root':
mysql> grant select, insert, update, delete on test.a to x;
mysql> grant select, insert, update, delete on test.b to x;
The problem is, if I connect to MySQL as user 'x', I can access any table in
DB 'test', when I only want to have access to tables 'a' and 'b'...
Any suggestions? Clues?
Thx in advance,
Tiago
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
