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, 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."'
Think of a role as permissions to do tasks whereas grant gives you access to objects. You are granted permission to a table/view etc. Your role is to create other users, or create databases I don't know any database system other than Postgresql so I don't know how it compares to Oracle -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin