Showing results for 
Search instead for 
Did you mean: 

Row deactivation

Row deactivation

Hi all,

does anyone know how to deactivate a row in Oracle table so that a user query doesn´t return that row?

Thank you.
Peter Godron
Honored Contributor

Re: Row deactivation

Senthil Kumar .A_1
Honored Contributor

Re: Row deactivation


What you might be looking for is Hiding. I'm not too sure if it is possible, becasue I do not know Oracle much.

Why don't you look at some fine-grained access control for rows ...

Senthil Kumar .A
Let your effort be such, the very words to define it, by a layman - would sound like a "POETRY" ;)
Sunil Kumar MK
Occasional Advisor

Re: Row deactivation

Another way of achieving(Apart from Views) this would be by using Oracle Label Security.

It offers a powerful implementation of row-based security that's perfect for restricting user access to specific data, especially in a data mart or data warehousing environment.

Note that Views are more simpler to implement. OLS is more complicated and requires more resources and efforts.