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."' -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin