Re: Views and security

From: Andre van Winssen <>
Date: Fri, 13 Nov 2009 15:36:35 +0100
Message-ID: <>

you mean something like:

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 <>

> 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.<>

Received on Fri Nov 13 2009 - 08:36:35 CST

Original text of this message