X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=portal-BE%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fportal%2Fdao%2Ffn%2FFnRoleDao.java;h=f979be6e8382cf33d474ba1ba8c857d2a350cfda;hb=ffd9af970318c1f5a0bad46d7aad5d4611414aae;hp=a87f31cc0b55532b1cf311124ae40e09adff7e42;hpb=dd4c51e4349b596766f2fda555a7a0d3ba46e9fa;p=portal.git

diff --git a/portal-BE/src/main/java/org/onap/portal/dao/fn/FnRoleDao.java b/portal-BE/src/main/java/org/onap/portal/dao/fn/FnRoleDao.java
index a87f31cc..f979be6e 100644
--- a/portal-BE/src/main/java/org/onap/portal/dao/fn/FnRoleDao.java
+++ b/portal-BE/src/main/java/org/onap/portal/dao/fn/FnRoleDao.java
@@ -68,6 +68,15 @@ public interface FnRoleDao extends JpaRepository<FnRole, Long> {
   @Query
   List<FnRole> retrieveAppRolesByAppId(final @Param("appId") Long id);
 
+  @Query
+  List<FnRole> retrieveActiveRolesOfApplication(final @Param("appId") Long appId);
+
   @Query
   List<FnRole> retrieveAppRolesByRoleNameAndByAppId(final @Param("roleName") String roleName, final @Param("appId") Long appId);
+
+  @Query
+  List<FnRole> getGlobalRolesOfPortal();
+
+  @Query
+  FnRole getSysAdminRoleId();
 }