views are not granted to default user

Question

views are not granted to default user

MartinMuzatko opened this issue 5 years ago · 4 comments

When creating a DB using init scripts, the TABLEs can be accessed by the user created with environment variables. However, the VIEWs are not accessible.

Can someone reproduce this?

Thanks!

Answer 1 · 2019-07-22T09:12:07.000Z

I found the problem, it was related to how the initdb scripts are executed. I documented that here already: #29

However, if I use the USE statement, the privileges are not assigned correctly.

Answer 2 · 2019-07-23T14:28:50.000Z

I can't reproduce, although i'm not entirely sure i understand you.

Answer 3 · 2020-01-17T16:49:15.000Z

Did you manage to resolve the issue?

Answer 4 · 2020-01-17T17:45:13.000Z

I can't remember actually that much, but looks like we don't have that problem anymore. I'll open again when I have a reproducible build. 👍 thanks