summaryrefslogtreecommitdiff
path: root/src/db/rest/util/_api_raise_deny.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/db/rest/util/_api_raise_deny.sql')
-rw-r--r--src/db/rest/util/_api_raise_deny.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/src/db/rest/util/_api_raise_deny.sql b/src/db/rest/util/_api_raise_deny.sql
new file mode 100644
index 0000000..17406b7
--- /dev/null
+++ b/src/db/rest/util/_api_raise_deny.sql
@@ -0,0 +1,16 @@
+CREATE FUNCTION _api.raise_deny()
+RETURNS BOOLEAN
+LANGUAGE plpgsql VOLATILE
+AS $BODY$
+BEGIN
+ PERFORM _api.raise(
+ _msg => 'api_denied',
+ _err => 403
+ );
+
+ RETURN TRUE;
+END
+$BODY$;
+
+GRANT EXECUTE ON FUNCTION _api.raise_null(TEXT)
+ TO rest_anon, rest_user;