There may be a simple answer to this that I just haven't found yet. I set up a PostgreSQL database in the webfaction control panel and have create a second user and assigned it to that database. It seems, though, that I can only give that second use either "Full Permissions" or "Owner" privileges. Is there a way to assign a user only Read-Only rights for a PostgreSQL DB? asked 19 Sep '16, 19:14 frearst |
If you want granular control of permissions you must use a Private Postrgres type app. The managed instance does not have this level of control. answered 19 Sep '16, 23:19 johns Thanks John, This is correct. For anyone else who happens to be looking for answers to this, documentation is here https://docs.webfaction.com/software/private-databases.html#private-postgresql-instances
(20 Sep '16, 20:53)
frearst
|