--创建视图.业务系统视图(asset_bus_view)
create or replace view asset_bus_view as
select group_uuid as id,
group_name as name,
parent_uuid as parentid,
note as description
from org_group
where logicdelete = '0';--授权视图
grant select on amsesa.asset_bus_view to aqgk;--创建视图.资产视图(asset_view)
create or replace view asset_view as
select
tt.id,tt.name,tt.resCategory,tt.resType,tt.ip,
tt.adminPort,tt.adminProtocol,tt.loginPort,tt.loginType,
tt.url,tt.status,tt.resGroups
from (
(
SELECT APP.RESUUID AS id,
AST.RESNAME AS name,
'APPRESOURCE' AS resType,
'' AS adminAcct,
'APPRES' AS resCategory,
AST.RESIP AS ip,
'' AS adminAcctPwd,
'' AS adminPort,
'' AS adminProtocol,
'' AS dbName,
'' AS domainCtrl,
'' AS domainDn,
'' AS enableAcct,
'' AS enableAcctPwd,
'' AS hostId,
'' AS instanceName,
'' AS loginAcct,
'' AS loginAcctPwd,
'' AS loginPort,
'' AS loginType,