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 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?
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