Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

DB user privilege options inconsistency

Discussion in 'General Discussion' started by thobarn, Jul 31, 2010.

  1. thobarn

    thobarn Well-Known Member

    Joined:
    Apr 25, 2008
    Messages:
    152
    Likes Received:
    1
    Trophy Points:
    68
    Location:
    sanctum sanctorum
    cPanel 11.25.0-R46156 - WHM 11.25.0

    When a DB user is being created using cPanel interface MySQL DB wizard, the final step gives privilege options for assignment to the user. If later modification of the user's privileges is needed, one of those options (EXECUTE) is not available, thus if granted during user creation cannot be revoked subsequently.

    Workaround is to delete and re-create the user, though inconvenient if the user is assigned to multiple DBs. Wizard is the only place EXECUTE privilege appears. During manual creation/assignment of a user this privilege option does not appear.

    FYI
     
  2. Miraenda

    Miraenda Well-Known Member

    Joined:
    Jul 28, 2004
    Messages:
    243
    Likes Received:
    3
    Trophy Points:
    168
    Location:
    Coralville, Iowa USA
    cPanel Access Level:
    Root Administrator
    While EXECUTE appears in the wizard, it doesn't actually apply to the user for a privilege. That interface (the wizard) put it into the GUI but didn't actually tie into the backend to provide the privilege. That is the actual issue, which was discussed in this thread:

    http://forums.cpanel.net/f145/mysql-execute-privilege-155598.html#post657333

    The EDGE cPanel should have this corrected already for all areas to be consistent and work with the privilege in question.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 Miraenda, Jul 31, 2010
    Last edited: Jul 31, 2010
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice