Re: Isolation of multiple databse instances provided by a single postgres server

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 21 Nov 2019 08:53:27 -0600



    On 11/21/19 8:42 AM, stan wrote:

    
      On Thu, Nov 21, 2019 at 08:18:21AM -0600, Ron wrote:

    
    [snip]

    
        Yes, but ... schema in Postgres are /different/ from Oracle schema.?? In
Postgres, the CREATE SCHEMA command creates a schema, whereas CREATE USER
creates a schema in Oracle.

      
      I am still struggling with the schema - role - user relationship in Postgres.
It appears to me there is one more layer than is needed/useful.
    
    
    For one thing, there are no users in Postgres anymore.

    
    https://www.postgresql.org/docs/9.6/sql-createuser.html

    
    CREATE USER is now an alias for CREATE ROLE. The only difference is that when the
      command is spelled CREATE USER, LOGIN is assumed by default,
      whereas NOLOGIN is assumed when the
      command is spelled CREATE ROLE.

    
    -- 

      Angular momentum makes the world go 'round.