Re: retrieve foreign keys list

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Sat, 21 Jul 2001 21:53:20 GMT
Message-ID: <3B2A4DB5.A497E105@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 asked here ... there is a 99.999+% chance he has CONNECT.

Daniel A. Morgan Received on Sat Jul 21 2001 - 16:53:20 CDT