Trigger if updating
Is that something can be achieved without using Triggers?
April 22, 2012 - am UTC you cannot really truly prevent the owner. Never grant anything on that column (do not grant update)Do not put code into the schema owner Lock the schema owner except for upgradessure, you could use a trigger and make everything slower for everyone (and still not solve the problem, I'm the owner, I'll just disable it).
I did not realize you can select columns in the update statement.
Figure 17-3 can i defined a check such that any user (even the owner) can insert the records into column 'x' but no update should be done on column 'x'?
So I dont want to do any checking.update emp set sal=sal 10,staus=nvl(status,'COMPLETE'); In this case I do want to do the checking.
With when clause even though the body does not get fired, it takes timing for checking here are stats I found.
This question is Hi Tom We got a de-normalized table with around 150 columns and around 50 millions rows. Dont you think we need such feature in Oracle, if not already available.
If you need i can show my script, which i used for testing.
I'd go withdo not grantdo not have code in owners schema (since that doesn't need grant, table schemas shouldn't have code anyway in most cases)do not allow owner to be a schema you log in as - it isn't necessary.
DBA's with "update any table" will of course be able to bypass that, but then again, they'd be able to bypass the trigger too - so so what.
does the 3rd party application owner care you are doing this?
Many 3rd party software owners would say "you are no longer supported if you do that" We have informed them and they are fine with this. November 06, 2012 - am UTC it seems risky, I wouldn't let you do it.