7 lines
334 B
MySQL
7 lines
334 B
MySQL
|
-- these commands must be given AFTER `panelcli setup` has been run
|
||
|
|
-- and ttrss has created its tables
|
||
|
|
-- having a 'ALTER DEFAULT PRIVILEGES IN SCHEMA public' might be a little cleaner than this
|
||
|
|
GRANT USAGE ON SCHEMA users TO apache;
|
||
|
|
GRANT SELECT ON TABLE users.users TO apache;
|
||
|
|
GRANT SELECT ON ALL TABLES IN SCHEMA public TO panel;
|