cancel
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.
3 REPLIES
Peter Godron
Honored Contributor

Re: Row deactivation

Senthil Kumar .A_1
Honored Contributor

Re: Row deactivation

Hi,

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 ...

http://www.dbazine.com/oracle/or-articles/jlewis16

Regards,
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.

OLS:
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.

Regards
Sunil