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 |
|
csphard
Posting Yak Master
113 Posts |
 Posted - 2006-11-16 : 12:21:59
|
| When you give database access.Meaning Permit is checkedDoes this give you access to the store procedures?Or do you have to do something else to make sure you can access those also.I have a vb app that uses crystal. I am using integrated security to run crystal. It is error say that I do not have EXECUTE permission on the store procedure |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-11-16 : 12:29:23
|
| look up GRANT EXECUTE in books onlineJay White |
 |
|
|
csphard
Posting Yak Master
113 Posts |
Posted - 2006-11-17 : 11:17:19
|
| My problem was that I switch databases. I select the login user group from the production database and added it to the databaseI had switch to. I kept most of the permissions but drop some permissions. I had to go in and add the EXEC permission to the store procedures the crystal reports were trying to use.thanks |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-11-17 : 13:28:16
|
| When you script out objects, choose to include the permissions going forward. always add the security groups first. THEN, take the scrips including permissions and add them. This will save you a lot of headaches in the future. It applies to switching databases and servers.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
store procedure access???