July 7, 2009 at 8:36 am
How do you create a Windows authorized SQL server login that only has permission to execute the stored procedures of a particular database?
September 1, 2009 at 4:45 am
Create logon on the SQL server then a Role on the DB that only allows access to SPROCS then link that back to the logon.
Hope this helps
September 3, 2009 at 2:59 am
cgr (7/7/2009)
How do you create a Windows authorized SQL server login that only has permission to execute the stored procedures of a particular database?
If you want it to have execute permissions on all stored procedures in that database, you can also say
use [databasename]
go
Grant execute to [YourUserName]
go
which will give you execute stored procedures or functions permissions in that database.
--------------------------------------------------------------------------------------
[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]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply