You have taken over managing a new database and in the process of finding out what you have gotten yourself into, you want to find answers to the following questions:
- Are there any unlimited quota assignments?
- Does anyone have the
UNLIMITED TABLESPACE privilege?
You decide to query the data dictionary to find answers to these questions.
Explain how you would find the answers to the above questions? Which data dictionary views would you query? Write the queries out and submit them. Also try them against your own database.