Re: Schema Naming Problem

One thing I should add is that the following works:

desc database.customer

thanks!

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.