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: How do you grant connection permission to a user?

Re: How do you grant connection permission to a user?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 28 May 2003 23:12:20 +0100
Message-ID: <3ed5341f$0$29708$cc9e4d1f@news.dial.pipex.com>


"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:s6t4dv4s923c0tl97q3rqfa4fbq53d03qh_at_4ax.com...
> On Tue, 27 May 2003 05:59:10 +1000, "Howard J. Rogers"
> <howardjr2000_at_yahoo.com.au> wrote:
>
> >I can sort-of understand people still believing that indexes should be
> >separated from tables for performance reasons. I can't believe or
understand
> >why anyone should be making totally dreadful recommendations like 'grant
> >connect'.
>
>
> Could you please have the issue adressed in the installation scripts
> Oracle delivers, or make it clear to *all* third-party vendors one
> shouldn't do this? CONNECT, RESOURCE, DBA is *OMNIPRESENT* in
> virtually *ALL* third-party software!!! (I'm not joking!)

I agree with the sentiment, but suspect that addressing it to a trainer may not exactly work. Actually addressing even Larry may not work, suppose peoplesoft/sap whomever forget to make the change or certify the app against 10i or whatever. Will Oracle live with non-certified apps or less secure clients than they could have if client DBAs understood the roles being granted by the app. After all you almost never buy a db, you buy the app.

-- 
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 May 28 2003 - 17:12:20 CDT

Original text of this message

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