Re: Question About Roles - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Question About Roles
Date
Msg-id 53B417AC.30301@aklaver.com
Whole thread Raw
In response to Question About Roles  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Question About Roles  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: David G Johnston
Date:
Subject: Re: How can I replace the year of the created_at column with the current year dynamically ?
Next
From: Rich Shepard
Date:
Subject: Re: Question About Roles