Data Dictionary Queries[Oracle]

Data dictionary queries - Exercise

User-related Data Dictionary Queries

Objective: Use data dictionary queries to view information about your users

Exercise scoring

You will get 5 points for each correct query, for a total of 10 points.

Background/overview

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.

Instructions

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.

Hints

UNLIMITED TABLESPACE is a system privilege. Unlimited quota is represented in DBA_TS_QUOTAS as a -1 in the MAX_BYTES field.

Submitting your exercise

Enter your answer into the text box below. Click the Submit button to submit the code.