[SQL] PostgreSQL Security/Roles/Grants

2009-11-01 Thread Andrew Hall
Hi, I come from an Oracle background and wonder if anyone could provide some background information on how best to implement an application security scheme in PostgreSQL using roles / grants. I'd just like to outline first how I'd approach security in Oracle: There is a notion of both: 1. De

Re: [SQL] PostgreSQL Security/Roles/Grants

2009-11-01 Thread Stephen Frost
Andrew, * Andrew Hall (andre...@hotmail.com) wrote: > 2. Non-default role -> a role which has to be explicitly activated during the > lifecycle of an application in order to gain access to database resources. > There are no limits on the number of non-default roles. This type of role > helps us