Schema Naming Problem

From: <berj_kacherian_not_at_hotmail.com>
Date: 2000/06/08
Message-ID: <8hmr6r$tk3$1@nnrp1.deja.com>#1/1

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.

Received on Thu Jun 08 2000 - 00:00:00 CDT