Daniel Audette <[EMAIL PROTECTED]> wrote: > > I would like to create a user that can create databases and do all the > necessary changes to it(select, insert, update, delete...), view all > database that he has been granted to see by other users except the > mysql.* I have created 1 user with the grant method but he can see all > the tables and probable edit them because I have used the > > grant all priviledges to [EMAIL PROTECTED] identified by 'somepass' > with grant option; > > How should I procede > > after I created the above user I tried to revoke select on mysql.* from > [EMAIL PROTECTED]; > > but i got the following error > ERROR 1141: There is no such grant defined for user 'myself' on host > 'localhost'
You can't give all permissions on the global level ( on all database) and then revoke privileges only from certain database(s). You should grant privileges on _each_ database you want user has access to. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]