Assuming you are running SQL Server, look at the GRANT command in BOL.

For example, you might use:

	GRANT UPDATE, INSERT
	ON YourTable
	TO db_user_adam


--
Jeff Mason              Custom Apps, Inc.
Jeff@c...


-----Original Message-----
From: Adam H-W [mailto:adam_hw@k...]
Sent: Thursday, March 13, 2003 12:57 PM
To: sql language
Subject: [sql_language] RE: sproc's


Great, thanks Jeff. One more thing - if I want to give permissions to a
certain db user, how would I go about that in the proc? For example, if the
username I wanted to give permissions to was called db_user_adam

thanks

Adam