I have a database view that is used by a Crystal report. I never got any issues, upon running the report (i.e. running the parameters of the report).
But, the end user got the following error message: Crystal: Failed to open a rowset Details: 42000 The SELECT permission was denied on the object....
This is shown in the attachment called "why". In the attachment called "why2", I took steps necessary to get rid of the error. As soon as he rebooted his machine, he no longer got any errors.
Does this mean the steps that I took are the only means of getting rid of this error?
I, also, created a User DSN that "speaks" to only that database that the view is in. Usually, I don't create User DSNs. I create System DSNs. But, the only DSN that showed up in Crystal when I created it was the User DSN. Why is that?
I'm just trying to understand what eliminated the error.