Hi
in the meantime i installed
mysql> select version();
++
| version() |
++
| 4.1.9-standard-log |
++
1 row in set (0.07 sec)
mysql>
[EMAIL PROTECTED]:~> uname -a
Linux rosetta 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i68
First of all you have an eroneus update statement:
UPDATE SET activ = 'inactiv' WHERE ident = 'fai'
After UPDATE the tablename must be pesent
UPDATE `tble_name` SET activ = 'inactiv' WHERE ident = 'fai'
Now next in line...
REVOKE all ON fai_accounts FROM 'fai'@'mydom.tld'
You are revok
Hi
turns me crazy: no reply button found in your ... mailing-list.
Hello.
Please send us an ouput of the following statement, which you should
perform in the middle of your test case:
show grants for current_user();
THIS IS THE OUTPUT:
DROP TABLE fai_accounts
DROP TABLE fai_contacts
DROP TABLE fai
Hello.
Please send us an ouput of the following statement, which you should
perform in the middle of your test case:
show grants for current_user();
Can you find, if your grants change? Can you reproduce a problem
on the latest release (4.1.9 now)?
schlubediwup <[EMAIL PROTECTED]> w
Hi again mysql-listers
regarding the problem i mentionned this morning:
for a description check out my message of this morning.
in the meantime i have found out
1. how to reproduce the problem
2. how to work around the problem
1. how to reproduce:
DROP TABLE afir_accounts ;
DROP TABLE afir_contact
Hi mysql-listers
mysql> select version();
++
| version() |
++
| 4.1.7-standard-log |
++
1 row in set (0.10 sec)
mysql>
[EMAIL PROTECTED]:~> uname -a
Linux rosetta 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686
i686 i386 G
