Re: Views and security

create table aap (c1 number,c2 number,c3 number); insert into aap values (1,2,3);
create view viewaap as select c1,null as c2, -9 as c3 from aap;

select * from viewaap;

SQL> select * from viewapp;

        C1 C C3
---------- - ----------

         1 -9

2009/11/13 J. Dex <cemail_219_at_hotmail.com>

> We are trying to implement some security via some views. Is it possible to
> create a view that shows all of the columns in the table, but some of the
> columns do not show the actual data? For example, column 1 would appear
> and it would be possible to see all of the data. Column 2 would show the
> column name but none of the data. What would the syntax for something like
> that be?
>
> ------------------------------
> Hotmail: Trusted email with powerful SPAM protection. Sign up now.<http://clk.atdmt.com/GBL/go/177141665/direct/01/>
>

--
http://www.freelists.org/webpage/oracle-l