section1 intro to oracle - Oracle 10 g express When you create a user you are also implicitly creating a schema for that user A schema is a logical

section1 intro to oracle - Oracle 10 g express When you...

This preview shows page 1 - 2 out of 2 pages.

Oracle 10 g express: 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. For example, HR.EMPLOYEES refers to the table named EMPLOYEES in the HR schema. (The EMPLOYEES table is owned by HR .) The terms database object and schema object are used interchangeably. When you drop (delete) a user, you must either first drop all the user's schema objects, or use the cascade feature of the drop operation, which simultaneously drops a user and all of his schema objects 1-Create new user: show them how to create a new user and grant him his main roles CONNECT Enables a user to connect to the database. Grant this role to any user or application that needs database access. RESOURCE Enables a user to create certain types of schema objects in his own schema. Grant this role only to developers and to other users that must create schema objects. This role
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '08
  • 5odfatrek
  • Relational model, Ulysses S. Grant, schema objects

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes