Re: Question About Roles

On 07/02/2014 06:17 AM, Rich Shepard wrote:

  Or, is that
> automatic if the role is included in the Users table?

To follow up on my previous post. If you have your own user table,
having a user in that table with the same name as one of the Postgres
role does not mean they pick up the Postgres role permissions. The
permissions apply to the role that the user connects as in the
connection parameters(or is changed to once connected). This is why
something like Django has it owns permissions system. The framework
connects to the database as a single role(which has sufficient Postgres
permissions) and when users log in they are tracked by the Django
permissions not by the Postgres system.

>
> Rich
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com