Re: Views and security
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 13 Nov 2009 07:47:53 -0800 (PST)
FYI
Someone set this up this way as a previous job.
You get questions as to why the view is broken because the values aren't
showing.
I prefer just setting up the view to show the columns they are allowed to see
instead answering phone calls as to why they can't see the data, that they
think the view is broken and/or well why am I not allowed to see this data and
Susie can?
Just my opinion.
K
--- On Fri, 11/13/09, Andre van Winssen <dreveewee@xxxxxxxxx> wrote:
From: Andre van Winssen <dreveewee@xxxxxxxxx>
Subject: Re: Views and security
To: cemail_219@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Date: Friday, November 13, 2009, 8:36 AM
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 <cemail_219@xxxxxxxxxxx>
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.
Other related posts:
