summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-02-13 09:59:29 +0100
committerYorhel <git@yorhel.nl>2021-02-13 09:59:31 +0100
commit2ef8638f424ddabb53cb8021ff20c3222dc4d426 (patch)
tree4a13d312fb66803e0a82c15b5715d148182a9ad5
parente0b30d79ff6aed3eff96710b382dede10c889d31 (diff)
SQL/perms: Fix setting the permissions on the users table
Broken in ac7afc01749881da4b427c0200b3e30558bfa8b0
-rw-r--r--sql/perms.sql6
1 files changed, 2 insertions, 4 deletions
diff --git a/sql/perms.sql b/sql/perms.sql
index b0f17172..272ce1f3 100644
--- a/sql/perms.sql
+++ b/sql/perms.sql
@@ -77,18 +77,16 @@ GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns_labels TO vndb_site;
-- protected and can only be accessed through the user_* functions.
GRANT SELECT ( id, username, registered, ip, ign_votes, email_confirmed, last_reports
, perm_board, perm_boardmod, perm_dbmod, perm_edit, perm_imgvote, perm_tag, perm_tagmod, perm_usermod, perm_imgmod, perm_review
- , skin, customcss, show_nsfw, notify_dbedit, notify_announce, notify_post, notify_comment
+ , skin, customcss, notify_dbedit, notify_announce, notify_post, notify_comment
, tags_all, tags_cont, tags_ero, tags_tech, spoilers, traits_sexual, max_sexual, max_violence
- , filter_vn, filter_release, vn_list_own, vn_list_wish
, nodistract_can, nodistract_noads, nodistract_nofancy, support_can, support_enabled, uniname_can, uniname, pubskin_can, pubskin_enabled
, ulist_votes, ulist_vnlist, ulist_wish
, c_vns, c_wish, c_votes, c_changes, c_imgvotes, c_tags),
INSERT ( username, mail, ip),
UPDATE ( username, ign_votes, email_confirmed, last_reports
, perm_board, perm_boardmod, perm_dbmod, perm_edit, perm_imgvote, perm_tag, perm_tagmod, perm_imgmod, perm_review
- , skin, customcss, show_nsfw, notify_dbedit, notify_announce, notify_post, notify_comment
+ , skin, customcss, notify_dbedit, notify_announce, notify_post, notify_comment
, tags_all, tags_cont, tags_ero, tags_tech, spoilers, traits_sexual, max_sexual, max_violence
- , filter_vn, filter_release, vn_list_own, vn_list_wish
, nodistract_can, nodistract_noads, nodistract_nofancy, support_can, support_enabled, uniname_can, uniname, pubskin_can, pubskin_enabled
, ulist_votes, ulist_vnlist, ulist_wish
, c_vns, c_wish, c_votes, c_changes, c_imgvotes, c_tags) ON users TO vndb_site;