select
SCH_OBJ.NAME ,
SCH_OBJ.ID ,
SCH_OBJ.CRTDATE,
USER_OBJ.NAME
from
(
select NAME, ID, PID, CRTDATE from SYS.SYSOBJECTS where TYPE$='SCH'
)
SCH_OBJ,
(
select NAME, ID from SYS.SYSOBJECTS where TYPE$='UR' and SUBTYPE$='USER'
)
USER_OBJ
where
SCH_OBJ.PID=USER_OBJ.ID
ORDER BY
SCH_OBJ.NAME
达梦数据库查询该模式所属的用户
最新推荐文章于 2024-07-19 15:18:01 发布