List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 24 2000 3:21pm
Subject:Re: SELECT privilege need to UPDATE?
View as plain text  
At 3:28 PM +0300 2000-06-24, <sinisa@stripped> wrote:
>Paul Baker writes:
>  > logged in as user mvdweb trying to make an update to a table with
>  > the following statement:
>  > mysql> UPDATE woheader SET orderno = 'W20000003' WHERE autono = 20000003;
>  >
>  > returned this error:
>  > ERROR 1143: select command denied to user: 'mvdweb@localhost' for 
>column 'autono' in table 'woheader'
>  >
>  > webuser has the following privileges: (from mysql.tables_priv)
>  > 
>+-----------+-----+--------+------------+----------------+----------------+---------------+-------------+
>  > | Host      | Db  | User   | Table_name | Grantor        | 
>Timestamp      | Table_priv    | Column_priv |
>  > 
>+-----------+-----+--------+------------+----------------+----------------+---------------+-------------+
>  > | localhost | mvd | mvdweb | woheader   | root@localhost | 
>20000624013654 | Insert,Update |             |
>  > 
>+-----------+-----+--------+------------+----------------+----------------+---------------+-------------+
>  >
>  > mysql version:
>  > # mysql -V
>  > mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
>  >
>  > I searched and searched through the mysql documentation and I could
>  > not find anything that says a user needs SELECT privilege to
>  > perform an UPDATE. I asked on #mysql on EFnet and no one seemed to
>  > have an answer for me. Is this a bug or did I miss something in the
>  > documentation somewhere?
>  >
>  > --
>  > =====================================================================
>  > Paul J. Baker                                         Rotz Technology
>  > pbaker@stripped                                     Senior Programmer
>  > phone (773) 862-6500 x 17                          fax (773) 862-6592
>  >
>
>
>Hi!
>
>Yes, documentation should be appended on this matter. It is because a
>search is performed on a column while column privileges are cached in
>table cache.
>
>Regards,
>
>Sinisa


Sinisa,
z
Will this also apply to other statements that may have a WHERE clause,
such as DELETE?

-- 
Paul DuBois, paul@stripped
Thread
SELECT privilege need to UPDATE?Paul Baker24 Jun
  • Re: SELECT privilege need to UPDATE?sinisa24 Jun
    • Re: SELECT privilege need to UPDATE?Paul DuBois24 Jun
      • Re: SELECT privilege need to UPDATE?sinisa25 Jun