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!

table-level permissions

Discussion in 'General Discussion' started by bobvance, Feb 24, 2004.

  1. bobvance

    bobvance Registered

    Feb 24, 2004
    Likes Received:
    Trophy Points:
    Atlanta, GA
    How can I set table-level permissions within MySQL database?

    It appears that CPanel only grants privileges for *all* tables within a database.
    What I desire is the ability to change permission on a PER-TABLE basis for a GIVEN USER. This is simple, standard SOP in MySQL databases.

    It could be achieved with a single simple GRANT statement by CPanel at database-creation time:

    grant all on user_database.* to user@localhost with grant option;

    This gives 'GRANT' privileges to *me* within my own database and then *I* can assign table-level permission, but only within this database. I think that the above statement should be executed on each DATABASE that is created via CPanel.

    We are given the ability to create tables and even databases, but we can't
    assign privileges to them ?!? It makes no sense to me


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