Here the contents of my privileged tables:
mysql.db table for dtk10mv after
GRANT UPDATE (status_dtk10) on tim.tk25no_meld to 'dtk10mv'@'localhost':
- db: -
- host: -
- user: Select_priv: Y
- tables_priv: Table_name: tk25no_meld; Table_priv: - ; Column_priv: Update
- columns_priv: Table_name: tk2
Hello.
I can see such behavior in test database because mysql.db table
has records which allows updates to any user, and database
privileges ORs with global privileges. Send us the contents
of your privileged tables. See:
http://dev.mysql.com/doc/mysql/en/request-access.html
Upgrade to
I tried the SHOW GRANTS statement
SHOW GRANTS FOR 'dtk10mv'@ 'localhost'
and got this:
Grants for [EMAIL PROTECTED]
GRANT SELECT, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'user1'@'localhost' IDENTIFIED BY PASSWORD '08862e71234184bc'
GRANT UPDATE (column1) ON database1.table1
Hello.
Use SHOW GRANTS statement to see all permissions which user has
and revoke unnecessary. See:
http://dev.mysql.com/doc/mysql/en/show-grants.html
http://dev.mysql.com/doc/mysql/en/grant.html
"Wolfgang Gliese" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I want one of my MySQL-us
From: "Wolfgang Gliese"
> - db: -
> - host: -
> - user: Select_priv: Y
> - tables_priv: Table_name: table1; Table_priv: - ; Column_priv: Update
> - columns_priv: Table_name: table1; Column_name: column1; Column_priv:
> Update
>
> What can I do?
I think you'd better reset the column_priv: Update
Hello,
I want one of my MySQL-users only update one of my columns in a table. I
used
grant UPDATE (column1) on database1.table1 to 'user1'@'localhost'
but the user1 can update other culumns too.
The mysql-db-table entries for user1 after grant command are:
- db: -
- host: -
- user: Select_priv: Y