oracle查询用户对象,Oracle查询数据库对象所属用户

Oracle查询数据库对象所属用户

--查询某用户下的表、视图

SELECT TABLE_NAME,OWNER,TABLE_TYPE FROM ALL_TAB_COMMENTS WHERE OWNER = 'VASS';

--查询某用户下的视图

SELECT VIEW_NAME,OWNER FROM ALL_VIEWS WHERE OWNER = 'VASS';

--查询某用下的索引

SELECT INDEX_NAME,OWNER,TABLE_NAME FROM ALL_INDEXES WHERE OWNER = 'VASS';

--查询某用户下的触发器

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE FROM ALL_PROCEDURES

WHERE OWNER = 'VASS' AND OBJECT_TYPE = 'TRIGGER';

--或

SELECT TRIGGER_NAME FROM ALL_TRIGGERS WHERE OWNER = 'VASS';

--查询某用户下的函数

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE FROM ALL_PROCEDURES

WHERE OWNER = 'VASS' AND OBJECT_TYPE = 'FUNCTION';

--查询某用户下的存储过程

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE FROM ALL_PROCEDURES

WHERE OWNER = 'VASS' AND OBJECT_TYPE = 'PROCEDURE'

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！