X-list: oracle-l Return-Path: Subject: RE: block a field From: Christian Antognini Message-id: F2C9CCA71510B442AF71446CAE8AEBAF205758@MSXVS04.trivadis.com Date: 2006-01-06 21:00:30 David >I should specify in more detail in my first message. Actually we want >blocking a field in an existing view, not a table. We don't want maintain >two sets of views and security. We prefer to modify those existing views. If you work with 10g you can use VPD's column masking. The feature allows you to let \ return NULL to un-authorized users. Give a look to DBMS_RLS.ADD_POLICY, especially to the \ parameter SEC_RELEVANT_COLS and SEC_RELEVANT_COLS_OPT. HTH Chris -- http://www.freelists.org/webpage/oracle-l