dbconf-perms.sql 334 B

123456
  1. -- these commands must be given AFTER `panelcli setup` has been run
  2. -- and ttrss has created its tables
  3. -- having a 'ALTER DEFAULT PRIVILEGES IN SCHEMA public' might be a little cleaner than this
  4. GRANT USAGE ON SCHEMA users TO apache;
  5. GRANT SELECT ON TABLE users.users TO apache;
  6. GRANT SELECT ON ALL TABLES IN SCHEMA public TO panel;