Re: retrieve foreign keys list
Date: Sat, 21 Jul 2001 21:53:20 GMT
Message-ID: <3B2A4DB5.A497E105_at_attws.com>
> But the Oracle manuals have been advising users for
> years that the CONNECT, RESOURCE, and DBA
> roles exist only for backwards compatibility and
> should not be used in future developments. Each site
> is supposed to design its own roles, so it is perfectly
> reasonable for the ALL_ and USER_ views to be
> unavailable at a well-controlled site.
>
> --
> Jonathan Lewis
They have ... and I drop them as soon as I install an instance.
But I have yet to visit a client site where they were not still in place and assigned as the defaults.
If our correspondent doesn't have a competent DBA on-site to ask the question he [Quoted] asked here ... there is a 99.999+% chance he has CONNECT.
Daniel A. Morgan Received on Sat Jul 21 2001 - 23:53:20 CEST