(I already wrote this question when I figured out the answer, do not give me any useful answers).
I am looking for something like a trigger that sets fire on Oracle Selection. The target removes specific rows based on the result of SELECT, which is SELECT the user.
It does not need to work on the standard version of Oracle 11G (Standard Enterprise), so I do not have access to rock-level security or fine-grained auditing.
I have found an existing (many) legacy applications in which thousands of embedded sites have been selected, so ideally I do not want to change every one ...
The table I am working there is one million rows in it, which limits me to a certain extent from a demonstration perspective.
Since I was looking to modify selection in only 1 special table, the answer for me To change the name of the existing table and create a view with the original name.
Comments
Post a Comment