Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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