Oracle System Privileges/Roles
CONNECT - allows users to logon
RESOURCE - allows users to create, manage, or drop database resources (such as tables) within their schema
DBA - allows users to create other userids, change user passwords, set auditing, access any data in the database, etc.
Many other granular roles exist, but these are the most important and most widely used