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