Jump to content

Recommended Posts

Posted

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 an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...