|
|
Posted by Alexander Kuznetsov on 10/02/54 11:45
Erland,
I think one more scenario for select * views is when a view is used as
a security tool. Suppose I expose a whole table to a user
grant select on sales to johnsmith
If later on I add a column to sales table, it is visible to johnsmith.
Suppose I expose to danbrown only his own sales via a view:
create view persons_own_sales
as
select * from sales where ...
grant select on persons_own_sales to danbrown
Again, If later on I add a column to sales table, I want it to be
visible to danbrown with minimum maintenance - just refresh the view.
Makes sense?
Navigation:
[Reply to this message]
|