| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: test and production on same database ??
Easy Solution:
Create the same tables on different schemas (Users) and schemanmes before
tables:
Ex. for table test and user datauser testuser
as user datauser
create table test (field1 varchar2(10));
as user testuser
create table test (feld1 varchar2(10));
select * from datauser.test;-- select from the data select * * from testuser.test;-- select from test
2.nd Solution:
Create the same tables on different schemas (Users) and work with synonyms.
Ex. for table test and user datauser testuser
as user datauser
create table test (field1 varchar2(10));
as user testuser
create table test (feld1 varchar2(10));
create public synonym test for datauser.test; select * from test; -- now selects from the data
drop synonym synonym test;
create public synonym test for testuser.test;
select * from test; -- now selects from the test
Catherine VOGEL wrote:
> 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++
--
 |
 |