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, 1735🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......