MySQL4, Rechte für Tabellenlocking

[Tom]

Hello,

ich selber habe MySQL 4 hier nicht installiert, kann die Aussage daher auch nur schwer nachvollziehen. Könnt Ihr mir helfen?

Angeblich bekommen User, für die das Lock-Tables Recht freigeschaltet ist, dadurch auch Rechte auf andere Datenbanken. Ich habe aber in Erinnerung, dass von Version 3 auf 4 die Rechtesteuerung eher restriktiver geworden ist. man kann in V4 viele Dinge nicht mehr sehen, die man in V3 noch sehen konnte.

Also hier nur nochmal dediziert dei Frage: Sind durch Freigabe von Lock-Tables auch andere Rechte des Users betroffen?

Harzliche Grüße aus http://www.annerschbarrich.de

Tom

[Bert Randolf]

Hallo

mysql> desc host; +-----------------------+-----------------+------+-----+---------+-------+

Field                 | Type            | Null | Key | Default | Extra |

+-----------------------+-----------------+------+-----+---------+-------+

Host                  | char(60) binary |      | PRI |         |       | Db                    | char(64) binary |      | PRI |         |       | Select_priv           | enum('N','Y')   |      |     | N       |       | Insert_priv           | enum('N','Y')   |      |     | N       |       | Update_priv           | enum('N','Y')   |      |     | N       |       | Delete_priv           | enum('N','Y')   |      |     | N       |       | Create_priv           | enum('N','Y')   |      |     | N       |       | Drop_priv             | enum('N','Y')   |      |     | N       |       | Grant_priv            | enum('N','Y')   |      |     | N       |       | References_priv       | enum('N','Y')   |      |     | N       |       | Index_priv            | enum('N','Y')   |      |     | N       |       | Alter_priv            | enum('N','Y')   |      |     | N       |       | Create_tmp_table_priv | enum('N','Y')   |      |     | N       |       | Lock_tables_priv      | enum('N','Y')   |      |     | N       |       |

+-----------------------+-----------------+------+-----+---------+-------+

mysql> desc user; +-----------------------+-----------------------------------+------+-----+---------+-------+

Field                 | Type                              | Null | Key | Default | Extra |

+-----------------------+-----------------------------------+------+-----+---------+-------+

Host                  | varchar(60) binary                |      | PRI |         |       | User                  | varchar(16) binary                |      | PRI |         |       | Password              | varchar(16) binary                |      |     |         |       | Select_priv           | enum('N','Y')                     |      |     | N       |       | Insert_priv           | enum('N','Y')                     |      |     | N       |       | Update_priv           | enum('N','Y')                     |      |     | N       |       | Delete_priv           | enum('N','Y')                     |      |     | N       |       | Create_priv           | enum('N','Y')                     |      |     | N       |       | Drop_priv             | enum('N','Y')                     |      |     | N       |       | Reload_priv           | enum('N','Y')                     |      |     | N       |       | Shutdown_priv         | enum('N','Y')                     |      |     | N       |       | Process_priv          | enum('N','Y')                     |      |     | N       |       | File_priv             | enum('N','Y')                     |      |     | N       |       | Grant_priv            | enum('N','Y')                     |      |     | N       |       | References_priv       | enum('N','Y')                     |      |     | N       |       | Index_priv            | enum('N','Y')                     |      |     | N       |       | Alter_priv            | enum('N','Y')                     |      |     | N       |       | Show_db_priv          | enum('N','Y')                     |      |     | N       |       | Super_priv            | enum('N','Y')                     |      |     | N       |       | Create_tmp_table_priv | enum('N','Y')                     |      |     | N       |       | Lock_tables_priv      | enum('N','Y')                     |      |     | N       |       | Execute_priv          | enum('N','Y')                     |      |     | N       |       | Repl_slave_priv       | enum('N','Y')                     |      |     | N       |       | Repl_client_priv      | enum('N','Y')                     |      |     | N       |       | ssl_type              | enum('','ANY','X509','SPECIFIED') |      |     |         |       | ssl_cipher            | blob                              |      |     |         |       | x509_issuer           | blob                              |      |     |         |       | x509_subject          | blob                              |      |     |         |       | max_questions         | int(11) unsigned                  |      |     | 0       |       | max_updates           | int(11) unsigned                  |      |     | 0       |       | max_connections       | int(11) unsigned                  |      |     | 0       |       |

+-----------------------+-----------------------------------+------+-----+---------+-------+

mysql> desc db; +-----------------------+-----------------+------+-----+---------+-------+

Field                 | Type            | Null | Key | Default | Extra |

+-----------------------+-----------------+------+-----+---------+-------+

Host                  | char(60) binary |      | PRI |         |       | Db                    | char(64) binary |      | PRI |         |       | User                  | char(16) binary |      | PRI |         |       | Select_priv           | enum('N','Y')   |      |     | N       |       | Insert_priv           | enum('N','Y')   |      |     | N       |       | Update_priv           | enum('N','Y')   |      |     | N       |       | Delete_priv           | enum('N','Y')   |      |     | N       |       | Create_priv           | enum('N','Y')   |      |     | N       |       | Drop_priv             | enum('N','Y')   |      |     | N       |       | Grant_priv            | enum('N','Y')   |      |     | N       |       | References_priv       | enum('N','Y')   |      |     | N       |       | Index_priv            | enum('N','Y')   |      |     | N       |       | Alter_priv            | enum('N','Y')   |      |     | N       |       | Create_tmp_table_priv | enum('N','Y')   |      |     | N       |       | Lock_tables_priv      | enum('N','Y')   |      |     | N       |       |

+-----------------------+-----------------+------+-----+---------+-------+

mysql> status

mysql  Ver 12.21 Distrib 4.0.15, (i686)

Connection id:          111635 Current database:       mysql Current user:           root@localhost SSL:                    Not in use Current pager:          stdout Using outfile:          '' Server version:         4.0.15 Protocol version:       10 Connection:             Localhost via UNIX socket Client characterset:    latin1 Server characterset:    latin1 UNIX socket:            /var/lib/mysql/mysql.sock Uptime:                 286 days 20 hours 46 min 1 sec

Threads: 2  Questions: 231942856436  Slow queries: 0  Opens: 35999  Flush tables: 1  Open tables: 64  Queries per second avg: 1.692

hoffe das reicht dir.

Bert