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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
