Reply to Re: views not updateable

Your name:

Reply:


Posted by Hugo Kornelis on 03/23/07 23:05

On 23 Mar 2007 03:13:01 -0700, othellomy@yahoo.com wrote:

>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...

Hi othellomy,

The REVOKE keyword is to revoke a permission that was earlier GRANTed
explicitly.

To explicitly deny access to an object that would by default allow
access, you use DENY:

DENY DELETE, INSERT, UPDATE ON v_t1 TO ALL

However, this will not affect any user in the db_owner database role or
any user in the sysadmin server role, since security checks are bypassed
for these users.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация