First, thank you for looking at my question.
The DB in question is an Oracle DB.
I know the first thing someone will say is check with your DB admin and get the correct privilege's.
The account I am using to access the DB has the required privilege's. I verified this by running the update query in Toad and it works fine, but when I run the same query in OutSystems I get the insufficient privilege's error.
I am not sure where to go from here.
Any thoughts, ideas, or solutions would be greatly appreciated.
Thank you
Hi Mike Rochel,
Maybe you are using a VPN or you are inside the work network, it could be that the server is blocking the ip of the outsystems server.
you could check it by trying to connect from another machine using the oracle client.
Thank you for your response.
I am using a VPN to connect to my work network. With that in mind I tried writing a select statement to test this theory. I would assume that if the server is being blocked I should get the same error even running a select.
I am able to run select statements and see the return data.
Also to I am doing all of this using the TEST button in the advanced quarry configuration window. Don't know if that makes any difference.
Hi Mike,
A few things to explore / consider :
You say your account has the right privileges, as demonstrated by Toad, but it is about the Outsystems application's db account, that's maybe not the one you are testing with ?
I'm not sure if this is still the case, but at some point in the past it was not possible to execute CRUD's from the service studio test facility of an sql widget. Do you get same problem when you run it with the published application?
I could imagine that you can only update Outsystems tables from an Outsystems application, is the update you are doing on an Outsystems table ?
I don't know any of this for sure, just trying to rule them out.
Dorine