| From: | Ray Stell <stellr(at)vt(dot)edu> |
|---|---|
| To: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: create role? |
| Date: | 2012-12-20 18:30:24 |
| Message-ID: | F873AF0B-B432-4B73-88CE-8D2361F2E345@vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 create role
> postgresql alter role
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, which seems rather system priv to me. MIght make for a handy additional comment to http://www.postgresql.org/docs/9.2/static/sql-grant.html 'For system privileges see "ALTER ROLE."'
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Williamson | 2012-12-20 22:12:47 | Re: Upgrade from 9.1.6 to 9, 1.7 seems to have caused a major slowdown |
| Previous Message | Baptiste LHOSTE | 2012-12-20 17:08:43 | Re: Autovacuum issues with truncate and create index ... |