Re: Schema Naming Problem

Database is (should be) a reserved word in 8.1 at least, since you can now create triggers

    'ON DATABASE' e.g. 'before truncate on database'

which will fire whenever any user issues a truncate command.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

berj_kacherian_not_at_hotmail.com wrote in message
<8ibet8$dud$1_at_nnrp1.deja.com>...


>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.