Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Relations of a User Account and a Schema

By: FYIcenter.com

(Continued from previous topic...)

What Is the Relation of a User Account and a Schema?

User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) that the user creates. The schema name is the same as the user name, and can be used to unambiguously refer to objects owned by the user.

(Continued on next topic...)

  1. What Is Oracle?
  2. What Is an Oracle Database?
  3. What Is an Oracle Instance?
  4. What Is a Parameter File?
  5. What Is a Server Parameter File?
  6. What Is an Initialization Parameter File?
  7. What Is System Global Area (SGA)?
  8. What Is Program Global Area (PGA)?
  9. What Is a User Account?
  10. What Is the Relation of a User Account and a Schema?
  11. What Is a User Role?
  12. What Is a Database Schema?
  13. What Is a Database Table?
  14. What Is a Table Index?
  15. What Is an Oracle Tablespace?
  16. What Is an Oracle Data File?
  17. What Is a Static Data Dictionary?
  18. What Is a Dynamic Performance View?
  19. What Is a Recycle Bin?
  20. What Is SQL*Plus?
  21. What Is Transport Network Substrate (TNS)?
  22. What Is Open Database Communication (ODBC)?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...