Managing Roles   «Prev  Next»

DBA_SYS_PRIVS view - Exercise

Objective: Query the DBA_SYS_PRIVS view.

Exercise scoring

This exercise is worth a total of 15 points.

Backgroun and Overview

One of your developers has come to you complaining that he cannot create objects in the USERS tablespace. Upon investigation, you find that there is no freespace left in USERS. Furthermore, you find that a user named JEFF has created several large tables in the tablespace. You did not think that JEFF had enough quota on the tablespace to create objects that large. Is it possible that JEFF holds the UNLIMITED TABLESPACE privilege?
Or does he just have a large quota. You need to find out what's going on.

Instructions

Which things would you check to figure out why JEFF can use up so much space? If you are planning to query any of the data dictionary tables, write those queries out.

Submitting your Exercise

When you are done with the exercise, click the Submit button to see the results.