Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

1018252Jun 20 2013 — edited Jun 20 2013

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.

Comments

Reddy007

Please reply issue is not solve yet...

Thanks

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 18 2013
Added on Jun 20 2013
#oracle, #schema, #sql, #user
4 comments
3,949 views