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" <ste...@vt.edu> 
To: pgsql-admin@postgresql.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@postgresql.org) 
To make changes to your subscription: 
http://www.postgresql.org/mailpref/pgsql-admin 

Reply via email to