Except for the DBA, who can perform any task, users must be granted the authority to perform specific tasks. For example, you need the proper authority to:
Connect to a database.
Create database objects, such as a database, table, index, or foreign key.
Alter the structure of database objects.
Insert, update, or delete data.
Select (view) data.
Execute procedures.
The DBA can grant any type of authority to any user. Sometimes other users can grant authority as well. For more information on what users can do, and how the DBA manages users, see Chapter 12, “Managing User IDs and Permissions.”
