RE: block a field

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