Ok let me explain my problem:
I do:
grant SELECT,alter,index,insert,update on SK_10.* to "admin-ab-44"
identified by "ab-44";
-- So the use get all right...
And :
revoke all on SK_10.users_profiles from "admin-ab-44";
-- So now they have all right except in SK_10.users_profiles ...
But the user cant always make a SELECT * from SK_10.users_profiles ;
I want admin-ab-44 get access everywhere except to the table
SK_10.users_profiles what can i do?
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
Fran�ois Boucher
[EMAIL PROTECTED]
---------------------------------------------------------------------
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