Select Permission on Local View - only erroring out sometimes?

Former Member
Former Member $organization

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 = 42000
Microsoft OLE DB Provider for SQL Server
List 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!

Parents Reply Children
No Data