Skip to content
This repository has been archived by the owner on Mar 21, 2023. It is now read-only.

PostgreSQL schema setup doesn't grant access #108

Closed
dpocock opened this issue Sep 14, 2016 · 1 comment
Closed

PostgreSQL schema setup doesn't grant access #108

dpocock opened this issue Sep 14, 2016 · 1 comment

Comments

@dpocock
Copy link

dpocock commented Sep 14, 2016

The UI wasn't working and I saw the error permission denied for relation user_menu in Apache error.log

I needed to log in to each database and run the command:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public  TO homer_user;

Maybe this (or a more fine tuned set of permissions) needs to be specified at the bottom of each schema_*.sql file for PostgreSQL

@adubovikov
Copy link
Member

done
f55c8fc
ade8274
0a23a3f

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants