This is a useful set of scripts for assessing the privileges assigned to all users of the Oracle system.
It lists the users to roles and system privileges followed by the system privileges to roles and users and finally the object privileges of each user.
Why privileges are needed in the database is explain in this document.
