Steve..

We are using Windows auth.

The VM staff tell me nothing has been changed in several weeks with the VMs etc. I have verified the server name and the server...

The error comes from the excel report, 'Select permission denied on object DB.Table'

It is the standard error message on the excel side when a user is actually denied permissions.

George, if I take the object in question in the EM, and list it's specific permissions the only listed permissions are select permissions for the correct set of IDs.

This...

I agree. I have done these same things. What is set up is an excel file which uses ODBC to open a view on SQL. At 3:00 PM...

That was my first thought. However, I did look at all the user IDs and the permissions for specific objects which were failing. In SQL the user does have permissions....

Thanks Paul,

So with the dimension table being nice thought, are you thinking nice for being able to lookup the possible values, and adding new ones sometime in the distant...

Thank you! I knew it was something simple I was missing.

The vendor apparently changed the file layout on me.

Well Jeff... that is why I am on this board all the time, learning better code and processes. I doubt the existing machine we have could handle the things it...

Thank you all for the tips and suggestions. It is good to see that there are others who, like me, think the hardware is cheap enough at the moment that...

I may have to play around with the network permissions, that seems workable. (Ofcourse, since I have had valid reasons to not get back to this, the people who use...

John Rowan (1/22/2010)

---

David Lester (1/22/2010)

---

Iowa here.

And it seems to suprise many, I have never even been on a farm, cause there is more here than farms... well here...

Iowa here.

And it seems to suprise many, I have never even been on a farm, cause there is more here than farms... well here specifically there are also...

I work in a medical insurance company (12 years now), from the IT end I am involved in most of the HIPPA related activities. As mentioned previously, the core...

Thank you Mark, this works well. It is what I was initially attempting to get to, I was not getting the sub-queries correctly.

I will have to file this one...

Hi Jeff, I see I forgot to mention in my post the attached file has the table defs, and data create statements etc.

Today I will be working on this, and...