On 12/12/07, Galen Charlton <[EMAIL PROTECTED]> wrote:
> Odd, it should check for 'ALL PRIVILEGES' or for specific grants,
> including 'DROP'.  Could you send me the output of the following mysql
> query:
>
> SHOW GRANT FOR 'kohaadmin'@'localhost';

Apparently kohaadmin is only granted SELECT. I guess I did something
wrong when I created that database.

Here is the reponse copied from the mysql shell (I just deleted the
long "--" lines).

+
| Grants for [EMAIL PROTECTED]
                                            |
+
| GRANT USAGE ON *.* TO 'kohaadmin'@'localhost' IDENTIFIED BY PASSWORD
'*CAAD8B29D8D65D2737D51F1A3F726F262C5EE65E' |
| GRANT ALL PRIVILEGES ON `mbom-test`.* TO 'kohaadmin'@'localhost'
                                            |
| GRANT SELECT ON `koha`.* TO 'kohaadmin'@'localhost'
                                            |
+


_______________________________________________
Koha-devel mailing list
Koha-devel@nongnu.org
http://lists.nongnu.org/mailman/listinfo/koha-devel

Reply via email to