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.

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