Johan Nilsson writes:
> Privileges question:
>
> I have a user in mysql.user and he has among each other DROP privileges, but
> if he creates a database and some tables in it, he can query a DROP table
> but can't run a DROP script... then he gets "Permission denied", but if I
> add him to the mysql.db table for this database with DROP privileges he can
> run a drop script? why, isn't the privileges from mysql.user inherited when
> running from the prompt (when running scripts)?
>
> Regards,
> Johan Nilsson
> Software Developer
> BeCon Mobile Internet AB, Sweden
> Web: http://www.beconmobile.com
> E-Mail: [EMAIL PROTECTED]
> Office: +46 457 44184
> Cellular: +46 709 798897
First :
Which MySQL version are you using. If not the most recent one, please
try it.
Next :
Do not meddle with privilege tables directly but use GRANT commmand
...
Last :
All privileges are inherited from global ones. Run SHOW GRANTS for
that user and see what it shows ....
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
