Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    79

    Unanswered: Create new schema

    Hi,

    How to create new schema in Oracle under "scott/tiger".
    I nee dthis to put all my app specific tables, etc of my project under this...

    Thanks!

  2. #2
    Join Date
    Nov 2003
    Location
    India
    Posts
    114

    Creating user

    Create user <user-name> identified by <password>

    but for executing this statement U mus have proper rights. For this U can log in from system user and execute statement

    grant dba to scott;

    this way Scott user will have Dba rights and u will be create new schema from this.

  3. #3
    Join Date
    Feb 2004
    Posts
    79
    Hi Varun,

    Thanks.So far so good.
    I could create the user "Bookkeeper" identified by my password.
    Now I dont see this schema , "Bookkeeper," in my structure in Oracle Enterprise Manager....
    where can I find thsi schema so then I can get started with creating roles, etc under it.

    Thanks!

  4. #4
    Join Date
    Nov 2003
    Location
    India
    Posts
    114

    hello

    HI

    Once U have created new user , U can simply log in from that user and do all U want. e.g Create Roles

    Just login from Bookkeeper.

  5. #5
    Join Date
    Feb 2004
    Posts
    79
    Thanks,

    Unfortunately now I get "connection closed" error.Seems I cant even get into Oracle ENterprise Management Server.But i can access tuff through SQLPlus WOrksheet.
    How do I fix this...
    Thanks!

Posting Permissions

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