On 2009-11-01, Andrew Hall wrote:
> 1. Default Roles -> a role which is activated at login time. Oracle imposes=
> a limit on the number of default roles which any given user can have.
>
> 2. Non-default role -> a role which has to be explicitly activated during t=
> he lifecycle of an applicati
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
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
