Re: Views and security
Date: Fri, 13 Nov 2009 09:32:28 -0500
You mean like how oracle hides the encrypted password values for 11g dba_users view?
Notice how oracle does it to mask data for dba_users:
select u.name, u.user#,
decode(u.password, 'GLOBAL', u.password, 'EXTERNAL', u.password, NULL), m.status,......
Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
"J. Dex" <cemail_219_at_hotmail.com>
11/13/2009 09:27 AM
Views and security
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:32:28 CST