Collections:
Show All User Accounts in the Database in Oracle
How To Get a List of All User Accounts in the Database in Oracle?
✍: FYIcenter.com
If you don't like to use a SELECT statement to get a list of all user accounts in the current database, you can use the Reports view to do this as shown in the following tutorial example. You need to connect to the server as SYSTEM to do this:
You should get a list all current user accounts in the database.
⇒ Show All Background Sessions in the Database in Oracle
⇐ Show All Tables in the Database in Oracle
2019-01-26, 1927🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...