Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Apr 2008
    Location
    sanctum sanctorum
    Posts
    152

    Default DB user privilege options inconsistency

    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. #2
    Member Miraenda's Avatar
    Join Date
    Jul 2004
    Location
    Coralville, Iowa USA
    Posts
    244

    Default

    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-...tml#post657333

    The EDGE cPanel should have this corrected already for all areas to be consistent and work with the privilege in question.
    Last edited by Miraenda; 07-31-2010 at 11:50 AM.

Similar Threads & Tags
Similar threads

  1. MySQL user loses lock tables privilege every day
    By veronicabend in forum cPanel and WHM Discussions
    Replies: 7
    Last Post: 08-21-2009, 01:54 PM
  2. mysql grant privilege to user
    By webstyler in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 03-13-2009, 05:21 PM
  3. Removing user options in CPANEL
    By daengo in forum New User Questions
    Replies: 2
    Last Post: 01-25-2008, 03:12 PM
  4. User Cpanel options
    By echo_bg in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 10-08-2005, 01:28 PM
  5. Cannot change a MySQL user's privilege.
    By PondRicefied in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 09-15-2005, 09:25 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube