charipg (9/21/2009)
how to provide the execute permissions to the stored procedures and select, update, delete rights on the tables to a perticular user?
As mentioned before in previous posts.
GRANT EXECUTE to [loginname]
will give execute permissions for procedures for that particular database.
as for DML Permissions
it is better to do that at object level so,
GRANT SELECT on [tablename] to [username]
GRANT DELETE on [tablename] to [username]
GRANT INSERT on [tablename] to [username]
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]