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
2019-07-21, 828👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...