Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Table is readonly - how to change?

Table is readonly - how to change?

From: Stefan Paege <paege_at_el-carls.de>
Date: Tue, 29 Jun 1999 16:26:16 +0200
Message-ID: <3778D788.C38B0674@el-carls.de>


First: I'm completely new to oracle. I have to create an app using Delphi that connects to an Oracle 8.0.5 server and writes records into a table. To create a testbed I got the 30 day trail version, installed it, started the schema manager, logged in as INTERNAL and created a new table called TEST in schema DEMO.
My app connects fine to oracle and logs in as user DEMO, but cannot insert data into the table.
From within the schema manager I try to add the object privilege for user DEMO to do INSERTs into TEST.
I get
  VAS-04025: INSERT ON DEMO.TEST unsuccessful   QRA-01031: Insuffient privileges

If I try the same from within the security manager I only get   QRA-01031: Insuffient privileges

What do I have to do?

BTW: I'm using the german Oracle 8, so my translations may not reflect the original terms of the english version.

--
Elektronik-Labor Carls
GmbH & Co KG

Stefan Paege


paege_at_el-carls.de, Tel ++49 (5973) 9497-23, Fax -19 Received on Tue Jun 29 1999 - 09:26:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US