Обсуждение: using schemas to create a virtual DB?

Hi,

I need to give some partners to a read only subset of my data. I'm currently looking at schemas, not something I've
lookedat or used before. 

Can I use schemas to create a virtual DB (built by views) onto my main DB? Or is this a dead end thought?

Cheers,

Bob


This message has been scanned but we cannot guarantee that it and any
attachments are free from viruses or other damaging content: you are
advised to perform your own checks.  Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.

On Monday 20 Sep 2004 1:58 pm, Bob Parkinson wrote:
> Hi,
>
> I need to give some partners to a read only subset of my data. I'm
> currently looking at schemas, not something I've looked at or used before.
>
> Can I use schemas to create a virtual DB (built by views) onto my main DB?
> Or is this a dead end thought?

You should look at views. Of course placing all related views in single schema
is a good idea..

 HTH

 Shridhar