1 files changed, 27 insertions, 0 deletions

diff --git a/notes/projects/radius/sql/ippool-database.sql b/notes/projects/radius/sql/ippool-database.sql
new file mode 100644
index 0000000..ed188cd
--- /dev/null
+++ b/notes/projects/radius/sql/ippool-database.sql
@@ -0,0 +1,27 @@
+/*
+ *  IP Engineering RADIUS Servers
+ *
+ *  ippool-database.sql - builds roles and database for RADIUS IP Pools
+ *
+ */
+
+
+CREATE ROLE radius_ippool WITH
+   NOSUPERUSER
+   NOCREATEDB
+   NOCREATEROLE
+   NOINHERIT
+   NOLOGIN
+   NOREPLICATION
+   NOBYPASSRLS
+   ADMIN admin;
+
+
+CREATE DATABASE radius_ippool WITH
+   OWNER       = radius_ippool
+   ENCODING    = "UTF8"
+   LC_COLLATE  = "en_US.UTF-8"
+   LC_CTYPE    = "en_US.UTF-8";
+
+
+/* end of sql */