diff options
Diffstat (limited to 'util/sql/perms.sql')
| -rw-r--r-- | util/sql/perms.sql | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/util/sql/perms.sql b/util/sql/perms.sql index a038103e..34a6550e 100644 --- a/util/sql/perms.sql +++ b/util/sql/perms.sql @@ -61,9 +61,9 @@ GRANT SELECT, INSERT, UPDATE, DELETE ON threads_posts TO vndb_site; GRANT SELECT, INSERT, UPDATE, DELETE ON traits TO vndb_site; GRANT SELECT, INSERT, UPDATE, DELETE ON traits_chars TO vndb_site; GRANT SELECT, INSERT, UPDATE, DELETE ON traits_parents TO vndb_site; -GRANT SELECT, INSERT, UPDATE, DELETE ON ulists TO vndb_site; -GRANT SELECT, INSERT, UPDATE, DELETE ON ulists_labels TO vndb_site; -GRANT SELECT, INSERT, UPDATE, DELETE ON ulists_vn_labels TO vndb_site; +GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_labels TO vndb_site; +GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns TO vndb_site; +GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns_labels TO vndb_site; -- users table is special; The 'perm', 'passwd' and 'mail' columns are -- protected and can only be accessed through the user_* functions. @@ -147,9 +147,14 @@ GRANT SELECT ON threads_posts TO vndb_multi; GRANT SELECT, UPDATE ON traits TO vndb_multi; GRANT SELECT ON traits_chars TO vndb_multi; -- traits_chars_calc() is SECURITY DEFINER GRANT SELECT ON traits_parents TO vndb_multi; +GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_labels TO vndb_multi; +GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns TO vndb_multi; +GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns_labels TO vndb_multi; + GRANT SELECT (id, username, registered, c_votes, c_changes, c_tags, ign_votes, email_confirmed, hide_list, notify_dbedit, notify_announce), UPDATE ( c_votes, c_changes, c_tags) ON users TO vndb_multi; GRANT DELETE ON users TO vndb_multi; + GRANT SELECT, UPDATE ON vn TO vndb_multi; GRANT SELECT ON vn_anime TO vndb_multi; GRANT SELECT ON vn_hist TO vndb_multi; |