Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: schema owner question

    As a newcomer to Oracle, here's a question that's been knawing at me:

    In our development environment, we'd like to have multiple people be able to create objects in a single schema. What I don't know is whether or not they would need to login with the schema owner's login/pwd, or if they can be given rights to create objects in a schema their login doesn't own.

    The key is to allow one person to create an object which another can alter/remove.


    So many questions, so little time

  2. #2
    Join Date
    Jul 2003
    no problem.
    this can be done many ways so I will not list them all.
    read up on privileges and roles.

    create table schema_owner.table_name (
    col1 vachar2(10));
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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