|
On a dedicated server WF account, I have a PG database for which I need to be able to establish a user/role with the CREATEROLE privilege (or grant that privilege to an existing user/role). If I understand WF terminology correctly (http://docs.webfaction.com/software/private-databases.html), the database in question is a "shared" rather than a "private" database. Can I set up such a user, and if so how? ~ Tx, Ken
This question is marked "community wiki".
asked 23 Nov '14, 03:20 kenatsun |
|
Yes, you will need to run a private postgresql cluster created from our control panel to be able to create database users with the CREATEROLE privilege. This is 'private' as in it runs as your user, in your home directory, and that user has full admin privileges over it. Databases and database users created using our control panel are on the server-wide install of PostgreSQL, which is shared between all customers on the server (albeit in your case you are the only one) and the database user's privileges there are limited. answered 23 Nov '14, 10:50 iliasr ♦♦ |
