Re: Basic Questions about PostgreSQL.

2021-09-15 Thread Adrian Klaver
On 9/14/21 10:10 PM, A Z wrote: -In PostgreSQL, what is the difference between Roles, Groups, and Policies exactly? What are they each, how do they relate to one another, and which one(s) can be assigned to another? Roles, groups and users have to do with project history more then anything

Re: Basic Questions about PostgreSQL.

2021-09-15 Thread Simon Riggs
On Wed, 15 Sept 2021 at 06:10, A Z wrote: > -Is there a simple, immediate, straightforward way to temporarily disable > PostgreSQL database > use of all other users, except development users, or in fact just one user > (one developer, yourself) > so that maintenance on the data or the data mode

Re: Basic Questions about PostgreSQL.

2021-09-15 Thread Tom Lane
rob stone writes: > On Wed, 2021-09-15 at 05:10 +, A Z wrote: >> -Is there a simple, immediate, straightforward way to temporarily >> disable PostgreSQL database >> use of all other users, except development users, or in fact just one >> user (one developer, yourself) >> so that maintenance on

Re: Basic Questions about PostgreSQL.

2021-09-15 Thread rob stone
On Wed, 2021-09-15 at 05:10 +, A Z wrote: > -In PostgreSQL, what is the difference between Roles, Groups, and > Policies exactly? What are they each, how do they relate to one > another, and which one(s) can be assigned to another? > > -Is there a simple, immediate, straightforward way to t

Re: Basic Questions about PostgreSQL.

2021-09-14 Thread David G. Johnston
On Wednesday, September 15, 2021, A Z wrote: > -In PostgreSQL, what is the difference between Roles, Groups > > There is none, aside from convention. Roles are generic, groups don’t get login rights while users do. You might want to clarify what you mean by policy since referencing the “create

Basic Questions about PostgreSQL.

2021-09-14 Thread A Z
-In PostgreSQL, what is the difference between Roles, Groups, and Policies exactly? What are they each, how do they relate to one another, and which one(s) can be assigned to another? -Is there a simple, immediate, straightforward way to temporarily disable PostgreSQL database use of all other