Re: Have you ever run grants from plsql?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 15 May 2001 23:02:03 -0700
Message-ID: <3B0217DA.A192E518@exesolutions.com>

Patxi wrote:

> I have to use the grant connect because the user has to connect to a remote
> data server using oracle. I don't know how to make possible to conect to a
> remote server without using the grant connect. Could you tell me where could
> I find information about it?

Granting CONNECT has absolutely nothing to do with connecting to any database anywhere. CONNECT is a role, not a privilege. And the role consists of lots of individual privileges. Some of which are appropriate for an end-user and some of which are just plain ridiculous IMO.

Grant the privileges you need. Not privileges that are irrelevant and could be misused.

Daniel A. Morgan Received on Wed May 16 2001 - 01:02:03 CDT