I'm running into a strange issue with SELECT permissions on a local view. I created a Local view for First Paid Performance based on T_TICKET_HISTORY and it does have
GRANT REFERENCES, SELECT on [LVS_TICKET_HISTORY_FIRST_PERF] to impusers granted on it.
I used it to build a new List Criteria too, which is working just fine when pulling/generating a list while a specific list is open in List Manager, but then gives me an error when I try to generate it from the main List Manager screen...
The error is
SQLSTATE = 42000Microsoft OLE DB Provider for SQL ServerList generation has failed.: Error 229, Severity 14, State 5, Procedure n/a, Line 1, The SELECT permission was denied on the object 'LVS_TICKET_HISTORY_FIRST_PERF', database 'impresario', schema 'dbo'.
Is there another place I need to grant permissions? Why would it be successfully generating in the new UI List Manager screen and not on the main screen? Any ideas anyone?? Thanks!
Lily,
What version of Tessitura are you using? In the more recent versions you need to grant SELECT permissions to [tessitura_app] in addition to [ImpUsers]. Try that and see if it works.
John
Thank you, that was absolutely it!
Much appreciated :)