Re: How to grant me permissions to my own tables ?

In article <399144f5_at_news.iprimus.com.au>, "Howard J. Rogers" <howardjr_at_www.com> wrote:
>
> Before you start jumping up and down about how awful Oracle is, why
> don't you stop to consider what that intervening ODBC layer is doing for
> you? As others have (and will) tell you, Oracle doesn't worry about
> case. You create table fred, it gets stored in the data dictionary as
> FRED. You query for table FrEd, it will find it. Unless -unless, you
> create the table with a name using a literal string (ie, inside quotes)
> -at which point, Oracle will do entirely the decent thing and say to
> itself, 'well, if this loony wants a case-sensitive table name, I'd
> better give it to him'.

I know that ODBC caused my current problem, but the e-mail related to my opinion of a language that at any time respects case, but does not preserve it.

>
> Listen: I'm no apologist for Oracle. Any database that sets PCTINCREASE
> to
> 50 by default wants its head tested. But CHECK YOUR FACTS AND
> CIRCUMSTANCES before proclaiming the product is at fault in a matter
> like this.

The fact still is that Oracle is a rarity in that it fails to preserve case, but respects it. I know it is only in a specific circumstance, but even so it is a significant flaw in the language. Received on Thu Aug 10 2000 - 00:00:00 CDT