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
