Re: Have you ever run grants from plsql?

From: Ludo Van Helleputte <Ludo.van.helleputte_at_be.pwcglobal.com>
Date: Sat, 19 May 2001 22:02:33 +0200
Message-ID: <3b06d4f4_3@news2.prserv.net>

I think GRANT / REVOKE are not allowed in PL/SQL, just like DDL commands (CREATE, ALTER, DROP, ...) ... you'll need to code this via dbms_sql or something ...

Good luck!
Ludo.

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B0217DA.A192E518_at_exesolutions.com...
> <snipped>
>
> 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 Sat May 19 2001 - 15:02:33 CDT