4 Replies Latest reply on Jun 20, 2013 9:06 PM by rp0428

    Multiple SCHEMA under a single USER, Multiple USERs associated to a single SCHEMA




      Please can you confirm which statements are true and which are false.


      1. A USER can have only one SCHEMA.
      2. A USER can have zero to many SCHEMAs.
      3. A USER can have one to many SCHEMAs.


      1. A SCHEMA can be owned by zero to many USERs.
      2. A SCHEMA can be owned by one to many USERs.
      3. A SCHEMA must be owned by one and only one USERs.


      USER in this case means Database Object.