Re: test and production on same database ??

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 13 Jan 2000 10:56:30 +0100
Message-ID: <947757488.19521.0.pluto.d4ee154e@news.demon.nl>

Create two different users/schemas containing production and test data, example app_prod and app_test
Create PUBLIC synonyms for the production schema, create PRIVATE synonyms for the test schema (of course each test user will need the private synonyms), as private synonyms are checked before public synonyms. Grant objects accordingly.

J'espere c'est une aide (not that I really still speak French, maybe my French is just as funny as your English)

--
Sybrand Bakker, Oracle DBA

Catherine VOGEL <cathy.vogel_at_twinsoft-sa.fr> wrote in message news:85k6fd$1nn$1_at_news.mgn.net...
> Hello
>
> Here is french asking !
>
> How can we do for having on same database one access on data of users and
> another access on data for tests ?
>
> congratulation for attentive responses
>
> best regards
>
> Jean-François Burgos
> A++
>
>
>
Received on Thu Jan 13 2000 - 03:56:30 CST