Re: ora-00942

Comments embedded.
On Mar 2, 4:29 pm, "ton de w" <ton_de_win...@xxxxxxxxxxx> wrote:
Hello,

I have attached a gateway to Oracle 9i. After applying various sql
files to create the required tables.
So I start the gateway and it logs in OK.
Then I see an ora-00942 error - table or view does not exist sqlcode
-943.

Well fair enough- perhaps the application _is_ trying insert a view or
table that does not exist. The problem is I cannot see which view or
tables the gw is trying to insert - at least not from the application
or gw.
It is not a permissions problem cos I am logging in as system .

Why are you using the SYSTEM account as your gateway login? Why on
earth would you use that account to create user tables for this
gateway?? This is a disaster waiting to happen, if it hasn't happened
already. A new account should have been created for the gateway user
and the necessary permissions should have been granted to this new
account. Why was this not done? I can only presume this was
laziness.


So my question is can I debug this at the Oracle end?

Probably. I would be using event 10046 and generating trace files so
you can see the actual SQL involved.

I daresay that if the insert was successful it could be audited - but
a failure?

Gee, an after servererror trigger would do just that. I suggest you
read the documentation at http://tahiti.oracle.com or go to www.psoug.org,
click on Morgan's Library and take a serious look at System Event
Triggers.


TIA

ton



David Fitzjarrell

.

Relevant Pages

  • Re: TS Gateway configuration/issues with non-domain membership
    ... If TSG is deployed in workgroup mode, you cannot use domain accounts to ... Yes - it seems that the network service (the service account for the TS ... Gateway) has no access to the private key. ... the certificate, the error won't appear. ...
    (microsoft.public.windows.terminal_services)
  • Re: Ooooopppps. Rights not right...
    ... the rights are correct for running 'ipconfig ... Would it be possible to have the script ... > gateway for the students and run the setclassid for the staff... ... >> user account? ...
    (microsoft.public.windows.server.general)
  • Changing Default Gateway
    ... Is it possible to change the default gateway in the TCP-IP settings, ... VB-script? ... I would like to have one account that has access ... to the internet, the other account should have no access to the internet ...
    (microsoft.public.scripting.vbscript)
  • Re: Reason #4,172 Never to Use a Debit Card
    ... card and have backup credit cards available even if I was stupid enough to do that. ... I keep a "gateway" account which handles all checking, ...
    (misc.consumers)
  • Re: ora-00942
    ... Why are you using the SYSTEM account as your gateway login? ... an after servererror trigger would do just that. ... box all to myself and any data will be test data from the gateway ...
    (comp.databases.oracle.server)