Re: Permission Evaluation



I just wanted to find out if an execution plan was created or not.

Bert

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:%2379WwHYHGHA.1452@xxxxxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxx> wrote in message
> news:eOxIXkSHGHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
>> 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
>>
>
>


.