X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=portal-BE%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fportal%2Fdomain%2Fdb%2Ffn%2FFnRole.java;h=3de581b19ecedf618cf4c3ab38e958019c80bb47;hb=39fb119cdaea6bd8d801b22d195db39f6d8faaca;hp=80617ba9763e81f231df23555b4fe96165a3b346;hpb=dd4c51e4349b596766f2fda555a7a0d3ba46e9fa;p=portal.git

diff --git a/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnRole.java b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnRole.java
index 80617ba9..3de581b1 100644
--- a/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnRole.java
+++ b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnRole.java
@@ -63,6 +63,7 @@ import javax.validation.constraints.Digits;
 import javax.validation.constraints.NotNull;
 import javax.validation.constraints.Size;
 import lombok.AllArgsConstructor;
+import lombok.Builder;
 import lombok.Getter;
 import lombok.NoArgsConstructor;
 import lombok.Setter;
@@ -110,7 +111,7 @@ CREATE TABLE `fn_role` (
         query = "FROM FnRole where roleName =:roleName and appId is null"),
     @NamedQuery(
         name = "FnRole.retrieveActiveRolesOfApplication",
-        query = "from FnRole where active_yn = 'Y' and appId=:appId"),
+        query = "from FnRole where activeYn = 'Y' and appId=:appId"),
     @NamedQuery(
         name = "FnRole.getUserRoleOnUserIdAndAppId",
         query = " FROM"
@@ -120,7 +121,16 @@ CREATE TABLE `fn_role` (
             + "  fr.roleId = fur.roleId\n"
             + "  AND fur.userId = :userId"
             + "  AND fur.appId = :appId\n"
-            + "  AND fr.activeYn = 'y'")
+            + "  AND fr.activeYn = 'y'"),
+    @NamedQuery(
+        name = "FnRole.getGlobalRolesOfPortal",
+        query = "from"
+            + "  FnRole"
+            + " where"
+            + "  roleName like 'global_%'"
+            + "  and appId is null"
+            + "  and activeYn = 'Y'"
+    )
 })
 
 @Table(name = "fn_role", indexes = {
@@ -128,6 +138,7 @@ CREATE TABLE `fn_role` (
 })
 @NoArgsConstructor
 @AllArgsConstructor
+@Builder
 @Getter
 @Setter
 @Entity