Jump to content

dante_forum

Members
  • Posts

    1
  • Joined

  • Last visited

dante_forum's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hi, on a Postgres database (stevie) I want to create a readonly role which is just able to select from existing tables. I created a new user and linked it to the database via the cPanel GUI. Then I revoked all create privileges on schema level and insert, update privileges on table level. However this user still can create tables and manipulate them. I noticed that HelioHost has enabled inheritance and all "Users" have disabled privileges. SELECT * FROM pg_roles; So the question is: How can I revoke privileges to a created user? Thanks and best regards, Dante
×
×
  • Create New...