0

I have a question I wanted to know the exact difference between user and schema? Can one schema have multiple users, if yes how?

Can someone please explain with good examples.

wolφi
  • 8,091
  • 2
  • 35
  • 64
Ashok Kumar Dabbadi
  • 235
  • 3
  • 6
  • 12
  • That depends on how you interpret the word "have". If you mean "can objects in a single schema be 'owned' by multiple users" the answer is No. If you mean "can objects in a single schema be **used** by multiple users" the answer is most certainly Yes. Share and enjoy. – Bob Jarvis - Слава Україні Feb 21 '14 at 14:17

1 Answers1

3

In Oracle user is equivalent to schema. So the answer is no.

Once you create a user eg. scott all objects created by user scott are within his schema. You can access objects from scotts schema by another user like this:

select * from scott.emp;
nKn
  • 13,691
  • 9
  • 45
  • 62
Lksh
  • 61
  • 1