Oracle Database 10g SQL (Osborne ORACLE Press Series)

In this chapter, you learned that

• A user is created using the CREATE USER statement.

• System privileges allow you to perform certain actions within the database, such as executing DDL statements.

• Object privileges allow you to perform certain actions on database objects, such as executing DML statements on tables.

• You can avoid having to enter the schema name by creating a synonym for a table.

• A role is a group of privileges that you can assign to a user or another role.

In the next chapter, you ll learn more about creating tables and see how to create indexes, sequences, and views.