Results 1 to 3 of 3

Thread: schema

  1. #1
    Join Date
    Apr 2007
    Posts
    1

    Unanswered: schema

    How to create a schema in oracle 9i database and how many types of schema r there in oracle 9i.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    It is USER you create, not schema (schema = user + all its objects (tables, indexes, views, procedures, ...)).

    CREATE USER praveencpk IDENTIFIED BY your_password;

    would be the simplest way to create a user. For more options, check documentation found at Tahiti or Oracle Technology Network (right here).

    As of "schema type" - how do you define it? Can you name a few of them, so that I could help you further? I'm not sure I know what this term should mean.

  3. #3
    Join Date
    Jul 2006
    Posts
    49
    When you create a user, using the CREATE USER command in SQL*Plus or an equivalent command in Enterprise Manager, Oracle creates a schema. There is a CREATE SCHEMA command in SQL*Plus, but it does not actually create a schema; the CREATE SCHEMA command just loads objects into an existing schema. The only way to create a schema is therefore to create a user with the CREATE USER command.

    There is one type of schema, but there are many types of users, which I know sounds confusing since schemas are supposed to be users. If you are using Oracle Internet Directory then you can create Oracle database users that have no schema, as one example of this dichotomy.

    Probably what you wanted to know is, are there different types of users like developers, administrators, etc. By default all users are created equal, and they have zero abilities in Oracle. After you create the user you must grant privileges and/or roles (a role is a group of privileges) to the new user. To make user BOB a developer you might "grant create session, resource to BOB". To make BOB an administrator you might "grant create session, dba to BOB".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •