> -----Ursprungligt meddelande-----
> Fran: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Skickat: den 19 juli 2001 15:36
> Till: [EMAIL PROTECTED]
> Kopia: [EMAIL PROTECTED]
> Amne: Re: inheritance of privileges?
>
>
> 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)?
> >
>
> First :
>
> Which MySQL version are you using. If not the most recent one, please
> try it.
Ver 11.15 Distrib 3.23.39, for Win95/Win98 (i32)
(While 3.23.40 isn't released for Win yet I can't test if it fixed or not.)
> Next :
>
> Do not meddle with privilege tables directly but use GRANT commmand
> ...
No I have not middle with it, I used GRANT ALL... while I'm developing at
the moment so I don't care what privileges I have.
> Last :
>
> All privileges are inherited from global ones. Run SHOW GRANTS for
> that user and see what it shows ....
Q: SHOW GRANTS FOR nisse
A: GRANT ALL PRIVILEGES ON *.* TO 'nisse'@'%' IDENTIFIED BY PASSWORD
'565491d704013245' WITH GRANT OPTION
I have not set any grants for the database I create, so it shall be
inherited from global ones (I think).
Then I run the drop script from the prompt and the following error occurres:
ERROR 6 at line 4: Error on delete of '.\besmart\client.MYI' (Errcode:13)
The file isn't read only!
The strange thing is if I delete via a connection it's all ok!
> --
> Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
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
---------------------------------------------------------------------
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
