Sohail Hasan <mysql@stripped> wrote:
> I have created a database and created a user with select rights to that
> database, there is a table name xyz in that database that I don't want
> that user to view, that's why i want to revoke that select rights from
> only that table, can anyone tell me what syntax of revoke would be used
You can't revoke SELECT privilege from the table if you grant privileges on the database.
You can grant SELECT privilege on each table that you want to be visible to user instead.
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net