Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coldfiretech
Starting Member
30 Posts |
 Posted - 2009-07-06 : 20:15:08
|
| Hello Everyone.I recently set up a database and i will have 3 different accounts that will be accessing the database.One to perform actions from a website.One to perform actions from a winforms app.One to perform actions from admin console.I made 1 login. And 3 different database users all connected to the same login.I want to set it up to only certain users can execute certain stored procedures and nothing else. I know how to set it up to where the can not execute queries against the tables just not the limited stored procedure execution i have no idea.Can anyone help me??Thanks,~Matt |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-07 : 04:34:51
|
| Hi..GOTO Database-->Security-->User-->choose the user or create the new user-->Securable-->Press the add button-->choose all objects-->choose stored procedures-->press ok-->there u can give the rights.. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-07 : 09:07:29
|
| Make sure they're not members of any of the following fixed database roles:db_ownerdb_datawriterdb_datareaderThen you can use the GRANT statement to grant specific permissions.GRANT EXECUTE ON <Stored proc name> TO <user name>--Gail ShawSQL Server MVP |
|
|
|
coldfiretech
Starting Member
30 Posts |
Posted - 2009-07-07 : 10:34:00
|
| Thanks GilaMonsterSucess comes before work only in the dictionary. |
|
|
|
|
|
|
Grant Execute on Stored Procedures?