Re: system user and grant

From: Fred Ruffet <fruffet_at_kaptech.com>
Date: Fri, 6 Aug 1999 16:05:19 +0200
Message-ID: <7oeq3p$sil$1@gatekeeper.ornano.kapt.com>

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

Yes but many applications are being developped simultaneously... In the last three months, 4 applications have been launched, and one which utilisation has started during its developpement (I know it's bad...), and number of tables is growing fast enough.

>No, How many objects have you in your application any way?

My database countains no more than 5368 objects (838 tables). My problem is that I already have 1313 synonyms (1079 are public synonyms). That's why I'd rather use private synonyms. One more reason is that I'd like users not to access all objects.

Regards,

Frédéric Ruffet - fruffet_at_kaptech.com Received on Fri Aug 06 1999 - 09:05:19 CDT