The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    153
    Likes Received:
    1
    Trophy Points:
    18
    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:
    242
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Coralville, Iowa USA
    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.
     
    #2 Miraenda, Jul 31, 2010
    Last edited: Jul 31, 2010
Loading...

Share This Page