his chapter focuses on how you can change users, databases, tables, and indexes you’ve created in the database, and it explores how you can change your session to meet your needs in Oracle and MySQL. The chapter is organized by the following topics:

   Users

   Databases

   Sessions

   Tables

   Views

   Indexes

As explained in Chapter 6, users are synonymous with schemas in an Oracle database, and they’re distinctly separate in a MySQL database. Databases are private work areas in both cases, and changes to them remain until you remove or change them again. Connections to your database management system are a session, and a session lasts only for the duration of your connection to a database or schema. Any changes to a session are lost when you break the connection by logging out or, in Oracle, by connecting as another user to another database. Tables are permanent structures unless you define them as temporary tables. Changes made to tables, like databases, last until you drop the table, undo the changes, or make new changes. As with tables, ind....