topic Re: Row deactivation in Operating System - HP-UX

Row deactivation

Manuel Gómez González — Tue, 23 May 2006 03:55:43 GMT

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.

Re: Row deactivation

Peter Godron — Tue, 23 May 2006 04:12:54 GMT

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

Re: Row deactivation

Senthil Kumar .A_1 — Tue, 23 May 2006 04:17:35 GMT

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

Re: Row deactivation

Sunil Kumar MK — Wed, 24 May 2006 04:32:38 GMT

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