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

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

    9b631776-4fa1-4f58-89e1-7d700432a1fc

      Hi,

       

      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.