View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 07:50 PM
Dan Guzman
 
Posts: n/a
Default Re: forbidding INSERTs and DELETEs

No permissions exist when a new object is created. Only privileged users
such as the object owner, sysadmin role members, the database owner and
db_owner role members have access until permissions are granted. To grant
only UPDATE permissions:

GRANT UPDATE ON dbo.MyTable TO SomeRole

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@poczta.onet.pl> wrote in message
news:4ltpa2hsjphrsifi2voj6kdr0vfcuh2f0c@4ax.com...
> Please help.
> I have a table with single row. I need to allow only UPDATEs of the
> table, forbid INSERTs and DELETEs. How to achieve it?
> Thank you for information
> /RAM/



Reply With Quote