Re: Schema/user/role - Mailing list pgsql-general

From David G. Johnston
Subject Re: Schema/user/role
Date
Msg-id CAKFQuwYyKyY3afn3fRj=j4+_SrarbKAU0qzmhRKS1HQUzumgFQ@mail.gmail.com
Whole thread Raw
In response to Schema/user/role  (DAVID ROTH <adaptron@comcast.net>)
Responses Re: Schema/user/role
List pgsql-general
On Mon, Mar 20, 2023 at 9:13 AM DAVID ROTH <adaptron@comcast.net> wrote:
Is there any good reference to explain the best usage of each of these structures.
I am coming from Oracle.  What is the best analog to Oracle's "user".

A schema is a namespace mechanism for objects.  It has no relationship to roles aside from the possibility, if you so choose, to define a schema to have the same name as a role, in which case that schema becomes parts of that role's default search_path.

There is no low-level difference between role and user.  A user is a role with the login privilege.

David J.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Schemas and Search Path
Next
From: Bryn Llewellyn
Date:
Subject: Re: Schema/user/role