user_app_v.sql

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

CREATE OR REPLACE VIEW USER_APP_V AS
SELECT  usr.user_id,usr.user_code,app.app_id, app.app_code, app.appdesc, '' as page_code, '' as pagePath,
        '' as patch_code
FROM 	SYS_USER usr,  
				SYS_APP app,
				(SELECT DISTINCT a.appGroup_ID, b.app_Code 
				 FROM SYS_APPGROUP_FEATURE a,
				 	  		   SYS_APPFEATURE b
				 WHERE a.AppFeature_Code = b.AppFeature_Code
				 AND   a.IsValid = 'Y'
				 AND   b.IsValid = 'Y') apc
WHERE      usr.AppGroup_ID = apc.AppGroup_ID
AND				app.App_Code = apc.App_Code