Posted by Danny on 09/29/68 11:33

In general its not a security concern unless you are restricting columns
through a view. New columns would show up (assuming the view was
refreshed). Basically select * should be avoided unless it is the intend to
expose all columns no matter what. The bigger concern is when it's embeded
in code. The code could break if columns are changed.


"Ray Allison" <ray.allison@tiscali.co.uk> wrote in message
news:43905829$1_2@mk-nntp-2.news.uk.tiscali.com...
> Is it bad practice to use 'Select * ' from a security perspective?
>
> Thanks for any advice.
>
> Ray
>

[Back to original message]