updating radius roles

1 files changed, 17 insertions, 3 deletions

diff --git a/notes/projects/radius/sql/radius-roles.sql b/notes/projects/radius/sql/radius-roles.sql
index c609c6f..c90ed55 100644
--- a/notes/projects/radius/sql/radius-roles.sql
+++ b/notes/projects/radius/sql/radius-roles.sql
@@ -20,7 +20,7 @@ CREATE ROLE radius
                     NOINHERIT
                     NOLOGIN
                     NOREPLICATION
-                    ADMIN wheel;
+                    ADMIN           wheel;
 
 
 CREATE ROLE radius_admin
@@ -29,7 +29,19 @@ CREATE ROLE radius_admin
                     NOCREATEROLE
                     INHERIT
                     NOLOGIN
-                    NOREPLICATION;
+                    NOREPLICATION
+                    ADMIN           radius;
+
+
+CREATE ROLE radius_app
+   WITH             NOSUPERUSER
+                    NOCREATEDB
+                    NOCREATEROLE
+                    INHERIT
+                    NOLOGIN
+                    NOREPLICATION
+                    ADMIN           radius
+                    ROLE            radius_admin;
 
 
 CREATE ROLE radius_user
@@ -40,7 +52,9 @@ CREATE ROLE radius_user
                     NOLOGIN
                     NOREPLICATION
                     NOBYPASSRLS
-                    ADMIN radius_admin;
+                    ADMIN           radius
+                    ROLE            radius_admin,
+                                    radius_app;
 
 
 /* end of sql */