user_appfeature_v.~sql

来自「用C＃开发的一套数据仓库的代码。（C＃＋ORACLE）」· ~SQL 代码 · 共 23 行

CREATE OR REPLACE VIEW USER_APPFEATURE_V AS
SELECT USR.USER_ID,
       USR.USER_CODE,
       APP.APP_ID,
       APP.APP_CODE,
       APP.APPDESC,
       APF.APPFEATURE_ID,
       APF.APPFEATURE_CODE,
       APF.APPFEATUREDESC,
       APF.MENUNAME,
       PG.PAGE_CODE,
       PG.PAGEPATH,
       RT.VIEW_ENABLED||rt.Append_Enabled||rt.Update_Enabled||rt.Delete_Enabled||rt.Export_Enabled AS ASSIGNED
  FROM SYS_USER USR, SYS_APPGROUP_FEATURE RT, SYS_APPFEATURE APF, SYS_APP APP, SYS_PAGE PG
 WHERE USR.USERSTATUS_CODE = 'ACTIVE'
   AND USR.APPGROUP_ID = RT.APPGROUP_ID
   AND RT.ISVALID = 'Y'
   AND RT.APPFEATURE_CODE = APF.APPFEATURE_CODE
   AND APF.ISVALID = 'Y'
   AND APF.APP_CODE = APP.APP_CODE
   AND APF.PAGE_ID = PG.PAGE_ID