Re: ora-00942

On 2 Mar, 23:18, "fitzjarr...@xxxxxxx" <fitzjarr...@xxxxxxx> wrote:
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 athttp://tahiti.oracle.comor go towww.psoug.org,
click on Morgan's Library and take a serious look at System Event
Triggers.



TIA

ton

David Fitzjarrell
Thanks very much for that David - event 10046 seems to be just what I
need.
I take your point about the system user - but actually I am on a test
box all to myself and any data will be test data from the gateway
(when i get it working ;-). But I see now that I need a separate
userid for tracing so perhaps I have been a bit lazy!




.

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
    ... So I start the gateway and it logs in OK. ... Why are you using the SYSTEM account as your gateway login? ... So my question is can I debug this at the Oracle end? ... you can see the actual SQL involved. ...
    (comp.databases.oracle.server)