Re: (Default) Group permissions

On 6/30/2013 12:46 PM, Michael Orlitzky wrote:
> We use Postgres for shared hosting; i.e. what most people use MySQL for.
> The biggest headache for us so far has been that we're unable to get
> group permissions set up effectively so that different groups of
> customers, admins, apaches, etc. can access/modify the data they need,
> without manual intervention from someone with root and a relatively deep
> knowledge of the permissions system.

90% of shared hosting is one user one database, right?

     CREATE USER username PASSWORD 'somepassword';
     CREATE DATABASE username OWNER username;

done.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast