如何在oracle 11g db中找到用户列表? [英] How to find the users list in oracle 11g db?

问题描述

如何查找用户列表，这些列表均在oracle 11g数据库中创建.是否有任何command可以找到我们可以从命令行界面执行的用户列表！

How to find out the users list, which is all created in the oracle 11g database. Is there any command to find out the users list which we can execute from the Command line interface!

推荐答案

我不确定通过从命令行界面执行"可以理解什么，但是您可能正在照顾以下select语句:

I am not sure what you understand by "execute from the Command line interface", but you're probably looking after the following select statement:

select * from dba_users;

或

select username from dba_users;

这篇关于如何在oracle 11g db中找到用户列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！