How to find the users list in oracle 11g db

Question

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

User · Answer

The command select username from all users  requires less privileges

User · Answer

You can try the following   This may be duplicate of the answers posted but I have added description   Display all users that can be seen by the current user   SELECT   FROM all users    Display all users in the Database   SELECT   FROM dba users    Display the information of the current user   SELECT   FROM user users    Lastly  this will display all users that can be seen by current users based on creation date   SELECT   FROM all users ORDER BY created

User · Answer

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    or  select username from dba users

User · Answer

You can think of a mysql database as a schema user in Oracle  If you have the privileges  you can query the DBA USERS view to see the list of schema

User · Answer

select   from all users   This will work for sure

User · Answer

I tried this query and it works for me   SELECT username FROM dba users  ORDER BY username    If you want to get the list of all that users which are created by end-user  then you can try this   SELECT username FROM dba users where Default TableSpace not in   SYSAUX    SYSTEM    USERS   ORDER BY username

[sql] How to find the users list in oracle 11g db?

Examples related to sql

Examples related to oracle11g