Summary


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.




Oracle Database 10g SQL
Oracle Database 10g SQL (Osborne ORACLE Press Series)
ISBN: 0072229810
EAN: 2147483647
Year: 2004
Pages: 217

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net