Users
How to Query User Quotas in Oracle Database The code below retrieves and displays information about user quotas on all tablespaces excluding the temporary tablespace (TEMP) on a Oracle database. Sample SQL Command 1col quota format a10 2select username, 3tablespace_name, 4decode(max_bytes, -1, 'unlimited', …
Read MoreOracle dba_users: List All User Account Information Purpose DBA_USERS is the data dictionary view that describes all users of the database. Each row is one account. The row shows the account status, the creation date, the default tablespace and the temporary tablespace. Other columns show the profile, the password …
Read More