| Permissions Issues? [message #154601] |
Mon, 09 January 2006 11:39  |
stevenh72
Messages: 1
Registered: October 2005
Location: Manchester
|
Junior Member |
|
|
Hi all
I am trying to narrow down why a query didnt run for me (I beleive its is due to permissions problems)
My question is this
Is it possible to run an update query from toad and be told x rows have been updated.
Then when running the update as a select you find the dataset has not updated as thought (a value in a field was not nulled).
If i didnt have the permissions shouldnt i have received a ora mesg box telling me that my permissions wouldnt allow this? (no error was shown)
NB when the permissions were changed the next day the query ran and updated correctly)
Could there be other explanations for why it didnt run..
Apologies for being so vague but Its outside my area and on discussion with the DBA he was pretty sure I should have had error messages
Regards Steven
|
|
|
|
|
|
| Re: Permissions Issues? [message #157657 is a reply to message #154601] |
Fri, 03 February 2006 11:40  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
As mentioned, the order of the statements would definitely matter.
Also, when it says x rows have been updated, it doesn't mean anything in particular has been done. It doesn't guaranteee that any net work was done as a result, or that what you thought would get updated got updated, or that there wasn't an after update trigger that changed a value after the update.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
