Re: several databases in 1 instance

From: Jim Kennedy <Jim_Kennedy_at_MedicaLogic.com>
Date: Wed, 27 Jan 1999 05:24:17 -0800
Message-ID: <DsEr2.7654$202.4005316@news1.teleport.com>

You can have several schemas which is probably what you want. Think of a schema as having an owner. So if you were doing an HR application and had an employee table and you needed one for test and one for production. You could have an owner called test and an owner called production (these are just examples).

You could have test.employee and production.employee tables for example. These are two separate tables and users logging in do not have to have rights to the other table.

Jim
agrudzinski_at_cs-controlling.de wrote in message <78mbua$9be$1_at_nnrp1.dejanews.com>...
>Hi,
>
>is there a possibility to work with several databases in 1 instance and
which
>restriction do I have with it ?
>
>Thanks,
>Astrid
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Jan 27 1999 - 07:24:17 CST