From 8bc2b364bd2c8fcccff12893136e1b3fb9211815 Mon Sep 17 00:00:00 2001
From: "David M. Syzdek" <syzdek@bindlebinaries.com>
Date: Fri, 24 May 2019 14:31:55 -0800
Subject: Updating privs

---
 notes/projects/radius/sql/ippool-functions.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

diff --git a/notes/projects/radius/sql/ippool-functions.sql b/notes/projects/radius/sql/ippool-functions.sql
index 3bbabdf..4757476 100644
--- a/notes/projects/radius/sql/ippool-functions.sql
+++ b/notes/projects/radius/sql/ippool-functions.sql
@@ -216,6 +216,9 @@ BEGIN
    RETURN FOUND;
 END;
 $$;
+GRANT EXECUTE
+   ON FUNCTION          ip_audit
+   TO                   radius_app;
 
 
 /*
@@ -301,6 +304,9 @@ BEGIN
 
 END;
 $$;
+GRANT EXECUTE
+   ON FUNCTION          ip_autoassign
+   TO                   radius_user;
 
 
 /*
@@ -471,6 +477,9 @@ BEGIN
    RETURN assignedIp;
 END;
 $$;
+GRANT EXECUTE
+   ON FUNCTION          ip_autoassign
+   TO                   radius_app;
 
 
 
@@ -505,6 +514,9 @@ BEGIN
    RETURN FOUND;
 END;
 $$;
+GRANT EXECUTE
+   ON FUNCTION          ip_release
+   TO                   radius_app;
 
 
 /*
@@ -758,6 +770,9 @@ BEGIN
 
 END;
 $$;
+GRANT EXECUTE
+   ON FUNCTION          netblock_audit
+   TO                   radius_user;
 
 
 /*
@@ -989,6 +1004,9 @@ BEGIN
 
 END;
 $$;
+GRANT EXECUTE
+   ON FUNCTION          pool_audit
+   TO                   radius_user;
 
 
 /*
@@ -1170,5 +1188,8 @@ BEGIN
 
 END;
 $$;
+GRANT EXECUTE
+   ON FUNCTION          region_audit
+   TO                   radius_user;
 
 /* end of sql */
-- 
cgit v1.2.3