Use a security role.
Revoke all direct permissions from any user to the table

Define a role MyTable_Role

Create the procedure that writes to that table.
Grant exec on the procedure to the role

Put the users in the role.



-----Original Message-----
From: Smith Ron L.
[mailto:mssqldba-ezmlmshield-x98618176.[Email address protected]
Sent: Tuesday, March 29, 2005 11:15 AM
To: LazyDBA Discussion
Subject: Update limited to a procedure
Importance: Low

Is there a way I can limit the update of a table so it can only be done
through a particular procedure?

Thanks!
Ron


Important Notice!!
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received
this message by mistake, then delete the e-mail message.
Thank you.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page