Re: privileges not updating
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. 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 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: privileges not updating
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 'moo' | | 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.. 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 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: privileges not updating
At 14:03 -0400 7/2/03, me wrote: 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 'moo' | | 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]
privileges not updating
hi everybody, 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 also if i create a database, grant privileges on it and then delete the db if i check grants - it still appears... what might be wrong? where should i look? the mysql is 4.0.13 on a redhat 8.0 box... thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]