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,
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
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
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
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.
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
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
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