From: | Lou Picciano <loupicciano(at)comcast(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, Ray Stell <stellr(at)vt(dot)edu> |
Subject: | Re: create role? |
Date: | 2012-12-20 14:45:22 |
Message-ID: | 202373801.1595767.1356014722327.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Ray,
PostgreSQL has a very powerful implementation of the ROLE/privileges model. Its control can be very granular, and very intricate! You really want to review your application's privileges/security needs before doing GRANTs with abandon.
To get what you need, though, the 'db user' simply needs the CREATEROLE privilege set.
Lou Picciano
----- Original Message -----
From: "Ray Stell" <stellr(at)vt(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Sent: Thursday, December 20, 2012 9:31:27 AM
Subject: [ADMIN] create role?
I have a app where the install guide says to give a db user the ability to create roles.
"Ensure that the user has permission to create database objects and can create roles."
How is that done...elegantly? Seems like the oracle idea of a role.
--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From | Date | Subject | |
---|---|---|---|
Next Message | Ray Stell | 2012-12-20 14:57:31 | Re: create role? |
Previous Message | Martin French | 2012-12-20 14:40:14 | Re: create role? |