20211120 - 로그인 인증 후 권한에 따른 메뉴 조회 Authorized Menu, Custom Navigation Menu

1. Shared Component >> Navigation Menu >> Create

Create List from Scratch

Name : Dynamic Navigation Menu

Type : Dynamic

2. User Interface Attribute

Navigation Menu >> Dynamic Navigation Menu 선택 

3. 로그인 후 권한에 따른 메뉴 구성

4. 권한별 메뉴 리스트에 대한 ERD 참고

SQL 참고

select level        "level"

     , page_nm      "label"

     , entry_target "target"

     , 'YES'        is_current

     , ''           image

  from (

         select mpage.page_nm, mpage.entry_target, mpage.dpseq, mgdtl.page_id, mgdtl.ppage_id

           from menu_grp_dtl mgdtl

              , menu_page    mpage

          where mgdtl.page_id  = mpage.page_id

            and mgdtl.mgrp_id in (

         select mgrp.mgrp_id

           from role_menu_grp rmgrp

              , user_mst      usermst

              , menu_grp      mgrp

          where upper(usermst.login_id) = :APP_USER

            and rmgrp.role = usermst.role

            and rmgrp.mgrp_id = mgrp.mgrp_id )

       ) menu_page

start with

    ppage_id = 1

connect by

    prior page_id = ppage_id

    order siblings by dpseq

참고.