Updating privs

1 files changed, 21 insertions, 0 deletions

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 */