Collections:
Show All User Accounts in Oracle
How To List All User Accounts in Oracle?
✍: FYIcenter.com
User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script:
>.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> SELECT * FROM ALL_USERS; USERNAME USER_ID CREATED ------------------------------ ---------- --------- FLOWS_020100 35 07-FEB-06 FLOWS_FILES 34 07-FEB-06 HR 33 07-FEB-06 MDSYS 32 07-FEB-06 ANONYMOUS 28 07-FEB-06 XDB 27 07-FEB-06 CTXSYS 25 07-FEB-06 DBSNMP 23 07-FEB-06 TSMSYS 20 07-FEB-06 DIP 18 07-FEB-06 OUTLN 11 07-FEB-06 SYSTEM 5 07-FEB-06 SYS 0 07-FEB-06
⇒ Create a New User Account in Oracle
⇐ Use Windows User to Connect to the Server in Oracle
2019-07-21, 1651🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...