From: | "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca> |
---|---|
To: | "Paul Förster" <paul(dot)foerster(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: UUID generation problem |
Date: | 2020-10-05 19:03:58 |
Message-ID: | bd85882f9ae2358dcde8af9a6f253ddf.squirrel@webmail.harte-lyne.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, October 5, 2020 13:34, Paul Förster wrote:
>
> well, actually, you can just set the search_path for the role the application
> logs in with:
>
> alter role <app_role> set search_path = '<schema>, pg_catalog, public';
>
> The next time <app_role> logs in, it should see the freshly set search_path.
>
> When we create an app schema and role set in our databases, we always do this
> to make sure that the application role always finds its schema. We never had
> any problems with this.
>
> https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH
> https://www.postgresql.org/docs/current/sql-alterrole.html
>
> Hope this helps,
> Paul
idempiere(5432)=# select schema_name
idempiere-# from information_schema.schemata;
schema_name
--------------------
public
information_schema
pg_catalog
pg_toast_temp_1
pg_temp_1
pg_toast
adempiere
(7 rows)
Do I infer from this that the application installer adds a schema called
adempiere; regardless of what username I choose for the database owner? Or did
I cause this selection of schema name through some explicit action of my own?
I also infer that this can be corrected in the manner suggested by issuing:
alter role idempiere-dbadmin set search_path = 'adempiere, pg_catalog, public';
Is this correct?
When I created the user adempiere I used this:
su - postgres -c 'createuser -S -d -r -l -P adempiere'
Now, man createuser says this:
. . .
-S
--no-superuser
The new user will not be a superuser. This is the default.
. . .
But, psql says this (somewhat compressed):
idempiere(5432)=# \du
List of roles
Role name | Attributes | Member of
adempiere | Superuser | {}
. . .
So, as I specified -S (--no-superuser when creating this user how comes it that
the adempiere username does, in fact, have the Superuser privilege? This is
not something that I am conscious of having granted. For that matter, I first
would have to research the exact command syntax to carry it out.
Something in the installer must be doing something to the adempiere role, but I
cannot find where.
--
*** e-Mail is NOT a SECURE channel ***
Do NOT transmit sensitive data via e-Mail
Unencrypted messages have no legal claim to privacy
Do NOT open attachments nor follow links sent by e-Mail
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
From | Date | Subject | |
---|---|---|---|
Next Message | James B. Byrne | 2020-10-05 19:09:31 | Re: UUID generation problem |
Previous Message | James B. Byrne | 2020-10-05 18:21:30 | Re: UUID generation problem |