List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:December 15 2003 9:06am
Subject:Re: REvoke select rights.
View as plain text  
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 
> here.

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
       <___/   www.mysql.com



Thread
REvoke select rights.Sohail Hasan15 Dec
  • Re: REvoke select rights.Egor Egorov15 Dec
    • Re: REvoke select rights.Sohail Hasan17 Dec
      • Re: REvoke select rights.Michael Stassen17 Dec