Search SSWUG.ORG:



DATABASES

Column-Level Security with DECODE


To restrict access to a certain column or columns within a table, you might create a view upon that table hiding unnecessary columns as needed. Sometimes, however, making a certain column completely inaccessible is not exactly what you’d like to get. Instead, you might mask the column values so that the user can access only those column values that she is authorized to access. This article illustrates how the DECODE function might be used for column masking.

Read this article..







comments powered by Disqus