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 |
|
calvinfoo
Posting Yak Master
129 Posts |
 Posted - 2011-10-31 : 00:24:16
|
| I got an error below. I set it to db_owner, then it works OK. But I wonder, what's the minimum requirement to exec SP, SELECT and UPDATE?I have two accounts:1. Read_only (SELECT, EXEC SP)2. Write_only (SELECT, UPDATE, EXEC SP etc..)These are general accounts I created for ASP script to execute. Or any better recommendation? Should I combine and use only one account?This question came to me when I faced Permission problem:Microsoft OLE DB Provider for ODBC Drivers error '80040e09' [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'SP_mySP', database 'myDatabase', schema 'dbo'. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-31 : 04:12:12
|
| usually you've two different types of users. one who has read access alone and one wit both read and write access. you'll be creating roles for that and link the users to corresponding roles------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
calvinfoo
Posting Yak Master
129 Posts |
Posted - 2011-10-31 : 04:15:51
|
| Ok, But my question is, how do I ensure the permission given is minimum? Currently the i set it as db_owner. Which I think is too much. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Minimum permission to EXEC, SELECT & UPDATE only