Re: Schema Naming Problem

I did the suggestion above and it worked. First of all thank you very much. But secondly any explanation of why this works? And the reason I am not posting a response to Bob's post is because Deja will not let me. I keep getting errors.

Also note that the word 'database' has to be uppercase. It will not work if it is lowercase.

Any further input on why Oracle acts this way would be greatly appreciated.

In article <8hmr6r$tk3$1_at_nnrp1.deja.com>,   berj_kacherian_not_at_hotmail.com wrote:
> I have a schema which is named DATABASE. Probably not the best name,
> but it happened. It works fine except I ran into this one problem. I
> granted select privileges to a couple of tables owned by DATABASE to
> another user. The other user tried to run the following select
> statement:
>
> select * from database.customer;
>
> Where DATABASE is the schema name and CUSTOMER is the table name and
> got the following error:
>
> select * from database.customer
> *
> ERROR at line 1:
> ORA-00933: SQL command not properly ended
>
> I will probably drop this user and create a new one. But what irks me
> is that I cannot find out why it is throwing this error. The word
> DATABASE is not a key word in the select statement. Any inputs to
 this
> would be greatly appreciated.
>
> Thanks!
>
> --
> Out the Ethernet, past the firewall, through the router, down the
> T1...nothing but Net
>
> In order to email me remove the '_not' from my email address.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Out the Ethernet, past the firewall, through the router, down the
T1...nothing but Net

In order to email me remove the '_not' from my email address.


Sent via Deja.com http://www.deja.com/
Before you buy.