Posted by Dan Guzman on 07/06/06 11:57

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/

[Back to original message]