Re: privileges not updating

[me]

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..

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]