Just after our V11 upgrade I'm getting this error on a couple of reports. Has something changed with Tessitura control group security that I've missed or forgotten about? The parameter in common to the reports having this error involves pulling a list of post_nos and checks against VRS_BATCH_TYPE. The parameter pull downs are fine in the client, but I observe that selecting directly against that table as dbo returns no results: perhaps the initial pull of data happens in the context of the client user, but then immediately control is passed over to ImpUser or the like, and ImpUser no longer has access to those rows in TR_BATCH_TYPE?
Any clues or suggestions would be appreciated,
Gawain
Im Not in today so can't check our setup. If you think its a security issue, if you have access to management studio, right click the table and click properties. There is a security tab on there. Click this and see if impuser has select access.
I would expect an error instead of no results returned.
What error are you getting as I cant see an attachment here.
How are you querying the table? Directly through management studio? What's your query syntax (just copy and paste what you're typing)
Wayne