[Dachs-support] permission denied for schema after run imp for the first time

Carlos Adean carlosadean at linea.gov.br
Wed Jan 17 17:40:58 CET 2018


Hi Markus,

I have been experiencing some permission issues with untrusted user. I really do not know when it started.

I think something is broke in our DaCHS installation, maybe after the last update (on June 2016).

After importing a new schema/table the user untrusted has no permission to usage the schema and I have to set it manually.

In the example below the schema cas does not exist yet.

$ gavo imp -v cas/q.rd 
Making data None
Starting /opt/dachs/inputs/cas/data/desdb.csv
Done /opt/dachs/inputs/cas/data/desdb.csv, read 999
Shipped 999/999
Rows affected: 999
** WARNING: Could not update timestamp on RD cas/q

$ psql -h desdb -U untrusted gavo

gavo=> select * from cas.get_pointings limit 10;
ERROR:  permission denied for schema cas
LINE 1: select * from cas.get_pointings limit 10;
                      ^

$ gavo --version
Software (0.9.7) Schema (14/14)


How can I fix it?



cheers,

--
Carlos Adean
IT Team
linea.gov.br
skype: carlosadean



More information about the Dachs-support mailing list