Re: system user and grant

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 27 Jul 1999 19:21:45 +0200
Message-ID: <933096095.22017.0.pluto.d4ee154e@news.demon.nl>

No, but of course you don't need to do that manually. Consider the following skeleton code (assuming you have been granted access) in sqlplus

set feedback off -

     pagesize 0 -
     newpage 0 -
     heading off

spool temp.sql
select 'create synonym '||object_name||' for '||owner||'.'||object_name||';' from all_objects
where owner = '&owner'
and object_type in
('TABLE','VIEW','FUNCTION','PROCEDURE','PACKAGE','SEQUENCE'); SPOOL OFF
SET FEEDBACK ON
START TEMP.SQL
EXIT And that is all.

Hth,

Sybrand Bakker, Oracle DBA

Fred Ruffet <fruffet_at_kaptech.com> wrote in message news:7nkhgh$uqp$1_at_gatekeeper.ornano.kapt.com...
> It's OK, but it's a problem which deals with something like a hundred
> tables. Is there no any other solution than creating a hundred synonyms ?
>
> Frédéric Ruffet - fruffet_at_kaptech.com
>
>
>
Received on Tue Jul 27 1999 - 12:21:45 CDT