Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: system user and grant

Re: system user and grant

From: Fred Ruffet <fruffet_at_kaptech.com>
Date: Wed, 28 Jul 1999 09:58:21 +0200
Message-ID: <7nmd7k$q8a$1@gatekeeper.ornano.kapt.com>


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...)

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 ?

Frédéric Ruffet - fruffet_at_kaptech.com Received on Wed Jul 28 1999 - 02:58:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US