Fred Ruffet a écrit :
Thanks a lot for your answer Sybrand.
It'll sure help me, but it makes me ask another question :
Imagine I have many developpers using my DB, and making tables, views
and so
on. When they finish their dev, they recreate all their new objects
with the
user we use to run all applications, in order for all programs to run.
If
developpers want to use the objects they've just created in an other
program, they'll have to use ownername.tablename, username.viewname
and so
on. You're script will make it be only tablename, viewname...
My problem is : Do I need to launch the script any time a set of objects
are
created or could it be run automatically ? (I'm not sure I've been
really
clear...)
Yes you can. Only you will have messages that already created synonyms
exist.A little precision however, the solution of public synonyms created
by DBA is better in your case as much as I can see. On the other hand it
can bbe automated but I would not do it! Generally creating objects in
an application is not so frequent after the first utilisation.
Another problem is that I'll have one synonym per object... isn't it
too
much ? I mean, wouldn't it make my DB too large for nothing ?
No, How many objects have you in your application any way?
--
Mohamad
Received on Wed Jul 28 1999 - 08:01:19 CDT
