Re: How to Handle new users in this senerio...

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Thu, 20 May 1999 13:50:03 +0200
Message-ID: <3743F6EB.AD2147CF@si.unirioja.es>

Forgot something:

Julio Negueruela escribió:

> At then end, you can create public synonyms for every object.
> spool create_public_synonym.sql
> select 'create public synonym '||object_name||' for '||object_name||';'=

> from user_objects
> /

You should include the clause:
where object_type in (<list_of_object_types_to_be_accessed>)

Regards.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Thu May 20 1999 - 06:50:03 CDT