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.

Deleting postgresql user will not revoke rights to tables

Discussion in 'Database Discussions' started by kjg, Oct 26, 2011.

  1. kjg

    kjg Well-Known Member

    Joined:
    Mar 2, 2004
    Messages:
    147
    Likes Received:
    0
    Trophy Points:
    16
    When using "cPanel - PostgreSQL Databases" to create and add a user to a postgresql database, that user will automatically be granted all permissions.

    I did not want that for this new user.
    So I deleted the user from the database via "cPanel - PostgreSQL Databases", but the user still has all the rights to each database table, view etc

    Deleting the user entirely via "cPanel - PostgreSQL Databases"did not help either. The user still has all rights to each database table, view etc.

    This is not what I read from:
    PostgreSQL Databases

    Any ideas how to get this to work?

    // kjg
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Just to clarify, the postgres database user was deleted but still exists as a user in postgres?
     
  3. kjg

    kjg Well-Known Member

    Joined:
    Mar 2, 2004
    Messages:
    147
    Likes Received:
    0
    Trophy Points:
    16
    Yes, the postgres database user that I earlier created and added to the database via "cPanel - PostgreSQL Databases" still was granted all rights to all tables, views etc after I deleted the user via "cPanel - PostgreSQL Databases"

    Using the deleted user on all tables worked fine.

    I solved it by revoking the user on all tables, views and sequenses, but the revoke should be automatic on users that are deleted from the database.
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Could you please submit a bug report about this issue using http://go.cpanel.net/bugs or using the link at the top of this forum? Any bugs must be reported using that interface and this sounds like an issue to me that a deleted user was still able to access databases.
     
  5. kjg

    kjg Well-Known Member

    Joined:
    Mar 2, 2004
    Messages:
    147
    Likes Received:
    0
    Trophy Points:
    16
    Bug reported.
     
Loading...

Share This Page