SELECT B.USERNAME,A.NAME SCHEMA_NAME
FROM SYSOBJECTS A,DBA_USERS B
WHERE A.PID=B.USER_ID
AND A.TYPE$='SCH'ORDERBY B.USERNAME;
---或者SELECT B.USERNAME,listagg(A.NAME,',') withingroup (orderby B.USERNAME) as SCHEMAS
FROM SYSOBJECTS A,DBA_USERS B
WHERE A.PID=B.USER_ID
AND A.TYPE$='SCH'GROUPBY B.USERNAME;
2、查看元数据信息可以去查看《DM8 DBA手册》，也可以参考oracle的相关dba_字典视图，比如：
模式拥有的对象：
select * from dba_objects where owner=‘模式名’；
表具体信息：
select * from dba_tables where owner=‘X模式’；
列具体信息：
select * from dba_tab_columns where owner=‘XXX’ AND TABLE_NAME=‘XXX’;
1、查询哪些用户拥有那些数据库（达梦里面相似的概念是模式）
SELECT B.USERNAME,A.NAME SCHEMA_NAME FROM SYSOBJECTS A,DBA_USERS B WHERE A.PID=B.USER_ID AND A.TYPE$='SCH' ORDER BY B.USERNAME; ---或者 SELECT B.USERNAME,listagg(A.NAME,',') within group (order by B.USERNAME) as SCHEMAS FROM SYSOBJECTS A,DBA_USERS B WHERE A.PID=B.USER_ID AND A.TYPE$='SCH' GROUP BY B.USERNAME;2、查看元数据信息可以去查看《DM8 DBA手册》，也可以参考oracle的相关dba_字典视图，比如：
模式拥有的对象：
select * from dba_objects where owner=‘模式名’；
表具体信息：
select * from dba_tables where owner=‘X模式’；
列具体信息：
select * from dba_tab_columns where owner=‘XXX’ AND TABLE_NAME=‘XXX’;