Re: [ADMIN] create role?

2012-12-26 Thread Gary Stainburn
On Thursday 20 December 2012 18:30:24 Ray Stell wrote: I'm not really that lazy, I was just stuck in the oracle world view (grant priv to user). Your search strings don't fit in that logic. It looks like sys privs are never provided by grant, rather create or alter. Hmm, sans CONNECT,

[ADMIN] create role?

2012-12-20 Thread Ray Stell
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

Re: [ADMIN] create role?

2012-12-20 Thread Martin French
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. CREATE ROLE ROLENAME LOGIN ENCRYPTED

Re: [ADMIN] create role?

2012-12-20 Thread Lou Picciano
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

Re: [ADMIN] create role?

2012-12-20 Thread Ray Stell
On Dec 20, 2012, at 9:45 AM, Lou Picciano wrote: To get what you need, though, the 'db user' simply needs the CREATEROLE privilege set. createrole is really hard to find when you search for create role. Thanks.

Re: [ADMIN] create role?

2012-12-20 Thread Gary Stainburn
On Thursday 20 December 2012 14:57:31 Ray Stell wrote: createrole is really hard to find when you search for create role. Thanks. I always prefix any google search with 'postgresql' then whatever I need. Try googling postgresql create role postgresql alter role The second one is to amend an

Re: [ADMIN] create role?

2012-12-20 Thread Ray Stell
On Dec 20, 2012, at 10:22 AM, Gary Stainburn wrote: On Thursday 20 December 2012 14:57:31 Ray Stell wrote: createrole is really hard to find when you search for create role. Thanks. I always prefix any google search with 'postgresql' then whatever I need. Try googling postgresql

[ADMIN] create role syntax

2008-07-10 Thread Dev
Hi,   Is it possible to have numbers as role names? I tried doing something like create role 1 login createdb but I get a syntax error, however if I have an alphabet before the number it seems to work. For example like create role x1 login createdb /Dev