nicht angemeldet
MySQL4, Rechte für Tabellenlocking
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
--
Fortschritt entsteht nur durch die Auseinandersetzung der Kreativen
Nur selber lernen macht schlau
Fortschritt entsteht nur durch die Auseinandersetzung der Kreativen
Nur selber lernen macht schlau
-
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
--
E492: Not an editor command: Wq ln -s /dev/brain