summaryrefslogtreecommitdiff
path: root/db/rest/post/api_post_insert.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--db/rest/post/api_post_insert.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/rest/post/api_post_insert.sql b/db/rest/post/api_post_insert.sql
index 9eb200c..02b9d8d 100644
--- a/db/rest/post/api_post_insert.sql
+++ b/db/rest/post/api_post_insert.sql
@@ -32,6 +32,8 @@ GRANT INSERT ON TABLE api.post
TO rest_user;
GRANT INSERT ON TABLE admin.post
TO rest_user;
+GRANT UPDATE ON TABLE sys.post_id_seq
+ TO rest_user;
CREATE TRIGGER api_post_insert_trgr
INSTEAD OF INSERT