Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#4140 Bug in privileges for routines

4.0.8
works-for-me
Marc Delisle
6
2013-11-13
2013-10-21
Kevin VDS
No

There seems to be a display bug concerning privileges for stored procedure (routines). See screenshot in attachment which gives a notice that I don't have privileges to add routines. Above the notice you also see I can't edit or drop the 'test' routine.

But when I just run the queries to do exactly the same there is no issue at all. So I do have the necessary rights. More: when I use the navigation tree on the left and use the link 'new' below 'procedures' I actually can ad a procedure...

So their seems to be a bug in the 'routine' landing page...

1 Attachments

Discussion

  • Marc Delisle
    Marc Delisle
    2013-11-08

    Which MySQL version are you using?

     
  • Kevin VDS
    Kevin VDS
    2013-11-08

    Server version: 5.5.31-MariaDB-1~squeeze-log - mariadb.org binary distribution

     
  • Marc Delisle
    Marc Delisle
    2013-11-08

    Ok. Anything special about the definition of the account you are using?

     
  • Kevin VDS
    Kevin VDS
    2013-11-08

    No, nothing at all.

     
  • Marc Delisle
    Marc Delisle
    2013-11-08

    I assume you are using phpMyAdmin 4.0.8. I cannot reproduce this problem on my server or on demo.phpmyadmin.net.

    Does your account have global privileges, or just privileges on some databases?

     
  • Kevin VDS
    Kevin VDS
    2013-11-08

    Indeed: 4.0.8

    I forwarded the other question to our db admin. I come back with an answer asap.

    K

     
  • Kevin VDS
    Kevin VDS
    2013-11-08

    Only privileges on databases, no global privileges.

     
  • Marc Delisle
    Marc Delisle
    2013-11-09

    Could you tell me the result of this query?
    SELECT CURRENT_USER();

    and the name of your database?

     
  • Kevin VDS
    Kevin VDS
    2013-11-09

    Result is:

    CURRENT_USER()
    eventpl@localhost

    database name is eventp_dbs-xxx

     
    Last edit: Kevin VDS 2013-11-09
  • Marc Delisle
    Marc Delisle
    2013-11-09

    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2013-11-09

    I think I have found the problem; just to confirm, please show me the results of
    SELECT * FROM INFORMATION_SCHEMA.SCHEMA_PRIVILEGES WHERE PRIVILEGE_TYPE = 'CREATE ROUTINE'

    If my guess is correct, TABLE_SCHEMA in the results will be something like eventplan_%

     
  • Kevin VDS
    Kevin VDS
    2013-11-09

    GRANTEE: 'eventpl'@'localhost'
    TABLE_CATALOG: def
    TABLE_SCHEMA: eventp_dbs-xxx
    PRIVILEGE_TYPE: CREATE ROUTINE
    IS_GRANTABLE: NO

     
  • Marc Delisle
    Marc Delisle
    2013-11-10

    But in your screenshot, the db name is eventplan_dbserv, please explain the difference between this and eventp_dbs-xxx.

     
  • Kevin VDS
    Kevin VDS
    2013-11-10

    Don't like the real name of our db in the open. So I changed it. In the posts. But is indeed exactly the same as in screenshot.

     
  • Marc Delisle
    Marc Delisle
    2013-11-10

    I think there is something wrong in the definition of your privileges. There should be a backslash before the underscore in the value of TABLE_SCHEMA. See https://sourceforge.net/p/phpmyadmin/bugs/3566.

     
  • Marc Delisle
    Marc Delisle
    2013-11-10

    • status: open --> pending
     
  • Kevin VDS
    Kevin VDS
    2013-11-13

    DB admin changed the privileges with the backslash and now it works. Thx.

     
    Last edit: Kevin VDS 2013-11-13
  • Marc Delisle
    Marc Delisle
    2013-11-13

    • status: pending --> works-for-me