Thanks Alex,
So just one more question then. How do I get multiple users to share the
same schema and the same data and still force authentication for each one?
--
Filip Hanik
System Architect
Digital Workforce
fhanik_at_pacbell.net
filip_hanik_at_hotmail.com
415-863 7676
Alex <alex.hudghton_at_capgemini.co.uk> wrote in message
news:7ig78b$a4r$1_at_taliesin.netcom.net.uk...
> No. If you think of 'schema' as another name for 'user' then this may
become
> clearer.
> Two users can have the same default tablespace, but their schemas will be
> separate by virtue of the fact they have different user names. They can
even
> own tables which are identical in every way (including name), but there
will
> be two tables existing because of the username - one will be user1.table
the
> other user2.table.
>
> Alex
>
> Filip Hanik wrote in message ...
> >Hi,
> >I'm pretty new to Oracle and I'm trying to figure out the concept
> >tablespaces and users' default tablespace.
> >If two users have two different tablespaces in the same database, are
they
> >not sharing the same database schema?
> >
> >A little clarification in this matter would really help,
> >
> >Filip
> >
> >--
> >Filip Hanik
> >System Architect
> >Digital Workforce
> >fhanik_at_pacbell.net
> >filip_hanik_at_hotmail.com
> >415-863 7676
> >
> >
>
>
Received on Wed May 26 1999 - 11:41:55 CDT
