On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote:
me <[EMAIL PROTECTED]> wrote:
i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the changes with GRANT an REVOKE should take effect immediately but they don't. i'm using command line....
How did you exactly update privileges? Show me the output of SHOW GRANTS for those users.ok... here is the output of the show grants before i try to change the privileges:
mysql> show grants for [EMAIL PROTECTED];
+---------------------------------------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED] |
+---------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD 'moooooooooo' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `mydb`.* TO 'myuser'@'localhost' |
+---------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)
to change the privileges for mydb - to add FILE - i do:
mysql> grant SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,FILE,INDEX,ALTER on mydb.* to [EMAIL PROTECTED]
this returns no errors....
after that i check privileges again: mysql> show grants for [EMAIL PROTECTED];
and i get exactly the same output as before (see up)..
if i try:
mysql> revoke INDEX on mydb to [EMAIL PROTECTED];
that one works - and if i grant it again - it works too... apparently the FILE privilege is not getting registered and i'm not sure why..
FILE is not a database-level privilege, it's a global privilege.
GRANT FILE ON *.* to 'myuser'@'localhost';
if any other suggestions - will be appreciated......
thanks...
also if i create a database, grant privileges on it and then delete the db if i check grants - it still appears...
It's normal behaviour: http://www.mysql.com/doc/en/GRANT.html
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
