LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)
-   -   show all user in oracle database (https://www.linuxquestions.org/questions/linux-general-1/show-all-user-in-oracle-database-552933/)

wantamad 05-10-2007 01:24 PM

show all user in oracle database
 
hello!

is there a command to show all users (not just the connected ones but all the users created) for a given oracle database in sqlplus?

all i saw in google was SHOW USER; which only showed me whoami :(

thanks!

uselpa 05-10-2007 04:23 PM

try "select * from all_users;"

wantamad 05-10-2007 05:10 PM

Thank You Very Much!!!!

sameer_545 06-04-2010 10:02 PM

select username from dba_users;


All times are GMT -5. The time now is 01:52 AM.