Bug #2744 | user privileges at database level incorrect | ||
---|---|---|---|
Submitted: | 12 Feb 2004 7:26 | Modified: | 21 Jun 2004 14:16 |
Reporter: | Tony Little | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Administrator | Severity: | S3 (Non-critical) |
Version: | 1.0.1a | OS: | Windows (Windows XP Client - Linux Server) |
Assigned to: | Michael G. Zinner | CPU Architecture: | Any |
[12 Feb 2004 7:26]
Tony Little
[18 Feb 2004 2:40]
Michael G. Zinner
Thanks for submitting the report. Could you tell me, has the user Table/Column privileges assigned (rows in mysql.tables_priv or mysql.columns_priv tables) or Schema privileges (rows in mysql.db table)? The schema privileges only show entries in the mysql.db table - so privileges for a complete schema. If the user has Table/Column privileges assigned you need to go to the options and enable the [Show Table/Column Privileges] option. Creating a manual entries with wildcards in the mysql.tables_priv has not been implemented yet. This will be fixed. But it is supposed to work with the mysql.db table. Could you verify this?
[18 Feb 2004 8:05]
Tony Little
In response to your question. Yes the privileges are in the mysql.db table. Following I am including a clip of 3 rows from the db table - there are many more, but they are similar to these 3. +------+---------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | +------+---------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ | % | ash_% | ash-user | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | | % | et_% | et-user | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | | % | ssk_% | ssk-user | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | +------+---------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
[21 Jun 2004 14:16]
Michael G. Zinner
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at http://www.mysql.com/downloads/