达梦数据库查询各模式对应的用户

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