Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you grant connection permission to a user?
"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