Re: mysql 4.0.11-gamma: TRUNCATE <table> bug

Hi!

On Mar 06, Dr. R. Rajaraman wrote:
> Dear Sergei,
>
> Thanks for the prompt reply.
>
> The user 'mps' has select permission only to
> table'mps' in msdindents.
> 'mps' has no permission to table 'test'
> as can be seen by the denial for select.
> But look at Truncate, it went through!
>
> I also noticed 'show grants' failed for 'mps' with
> access denied to 'mysql' (see the last sequence)
> As I have not given permission to 'mps' to access any
> other database except 'msdindents', Is mysql not able
> to resolve the permission?

Without privileges on database mysql, user can see only his own grants.

What

SHOW GRANTS FOR 'mps'@'127.0.0.1';

and

SELECT DATABASE();

show ?

And - check if there is anything in mysql.db table
(your mps user cannot do it, try as a user who has access to database
mysql, or simply check that db.MYD has zero size).

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13911@lists.mysql.com
To unsubscribe, e-mail