Row deactivation

[Manuel Gómez González]

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]

Manuel,
either create views or VPD.
See
http://www.experts-exchange.com/Databases/Oracle/Q_21829825.html
and
http://www.securityfocus.com/infocus/1743

[Senthil Kumar .A_1]

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

[Sunil Kumar MK]

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