|
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/
Navigation:
[Reply to this message]
|