The following data dictionary views contain information about database users and profiles:
Describes tablespace quotas for users.
Describes the password profile parameters that are assigned to the user.
Displays the resource limits for the current user.
Displays all profiles and their limits.
Lists the cost for each resource.
Lists session information for each current session. Includes user name.
Lists user session statistics.
Displays decoded statistic names for the statistics shown in the
Describes users who can assume the identity of other users.