diff options
author | Yorhel <git@yorhel.nl> | 2021-02-13 09:59:29 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-02-13 09:59:31 +0100 |
commit | 2ef8638f424ddabb53cb8021ff20c3222dc4d426 (patch) | |
tree | 4a13d312fb66803e0a82c15b5715d148182a9ad5 | |
parent | e0b30d79ff6aed3eff96710b382dede10c889d31 (diff) |
SQL/perms: Fix setting the permissions on the users table
Broken in ac7afc01749881da4b427c0200b3e30558bfa8b0
-rw-r--r-- | sql/perms.sql | 6 |
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; |