In the Schema Browser, I bring up the list of Users. There are no icons to the right of the name to show status and under the info tab, it only lists the name, id, and create date. I am expecting more information like tablespace, status, profile, etc. to also be noted in the details section (right hand side when a user is selected).
Why is this information missing?
Current connection to the database lacks Oracle privileges.
Please log on to the database with a User with DBA privileges that can run a query on DBA_Users.
This is the query that Toad runs when logged on with dba privs that will show more status information:
Select *
FROM dba_users
WHERE username = :x
This the query that Toad runs when logged on to a user with limited privs that will show less status information:
Select *
FROM all_users
WHERE username = :x
