Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CONNECT ROLE

Re: CONNECT ROLE

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 28 Aug 2002 08:53:27 +0100
Message-ID: <3d6c8177$0$236$ed9e5944@reading.news.pipex.net>


"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D6BBEF8.69B2B63B_at_exesolutions.com...
> Have you looked at what is wrapped up in CONNECT?
>
> CREATE DATABASE LINK? Why? Why would anyone want any user to be able to do
this?
>
> CREATE CLUSTER? What end-user could possibly have a clue about clusters?
>
> One compromises system security ... the other lacking in any reasonable
context.

As I think I pointed out an application developer may well need some or all of these privs. Though you are probably correct about dblinks. If the damn thing had been called APP_DEVELOPER or some such methinks a lot of the trouble would have been avoided.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Wed Aug 28 2002 - 02:53:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US