Posted by othellomy on 03/23/07 10:13

On Mar 23, 4:06 pm, othell...@yahoo.com wrote:
> How do I make a view non updateable? I want to create a view so that I
> will not be able to update, insert or delete the view so that base
> table is not affected (except dropping the view itself). Thanks.

I have tried:
revoke delete,insert,update on v_t1 to dbo

bit its not working...

[Back to original message]