Permission Evaluation

Can anyone tell me when SQL evaluates permisions? If I execute "Select *
from table1" and I don't have select permission on table1, is an execution
plan created?
BertHi
If you don't have SELECT permission ,SQL Server identifies it internally
and throws the error. Why do you bother about it?
"T. Bert Penney" <bpenney@.nospam.oanet.com> wrote in message
news:eOxIXkSHGHA.3936@.TK2MSFTNGP12.phx.gbl...
> Can anyone tell me when SQL evaluates permisions? If I execute "Select *
> from table1" and I don't have select permission on table1, is an execution
> plan created?
> Bert
>|||I just wanted to find out if an execution plan was created or not.
Bert
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%2379WwHYHGHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi
> If you don't have SELECT permission ,SQL Server identifies it internally
> and throws the error. Why do you bother about it?
> "T. Bert Penney" <bpenney@.nospam.oanet.com> wrote in message
> news:eOxIXkSHGHA.3936@.TK2MSFTNGP12.phx.gbl...
>