• Replies 1 reply
  • Subscribers 336 subscribers
  • Views 46 views
  • Users 0 members are here
Related

Changes to FT_CONTROL_GROUP in V12.5.1

Tom Brown (Past Member)
$organization

When moving to Tessitura 12.5.1 has anyone noticed that local created secure views that reference Tessitura Standard Secure views are no longer working?

We are getting error messages like 

"[DataSource.Error] Microsoft SQL: The SELECT permission was denied on object VXS_CUST_MEMBERSHIP, database 'impresario', scheme 'dbo'.

We also reference views like

  • vs_campaign
  • vs_MEMB_ORG

in some of our in-house views.

I have noticed changes to dbo.FT_CONTROL_GROUPS.  The Comments say:

"Modified CWR 1/13/2015 #9573 Changes to improve performance (changing UNION TO UNION ALL)"

We had a number of Local Secure views that used secured views that are not working.

Any insights that other might have would be helpful.

1. Have you seen these problems?

2. Have you established a work around to this?

3. Is this a know defect?

 

Parents
  • $organization

    Hi Tom,

    We have been on v12.5.1 since early February and haven't noticed a problem like this. The error you mention seems more like a permission for the ImpUsers role might be somehow missing on the VXS_CUST_MEMBERSHIP view... It would be good to check that if that hasn't been done already.

    We don't have a local view that uses VXS_CUST_MEMBERSHIP specifically, but I just tested our lvs_phone view, which uses vrs_phone_type (which uses ft_control_groups) and it works. I did the test in SSMS, but I used a SQL user setup in the same way as a typical user (i.e. access to ImpUsers role in impresario, but no other elevated permissions) and used ap_set_context so that it ran in the context of one of our user groups. I confirmed that it limited the phone data to only the control groups that Tessitura security group has access to. I also confirmed I was able to select data out of VXS_CUST_MEMBERSHIP.

    I hope that helps.

    Thanks,
    David 

Reply
  • $organization

    Hi Tom,

    We have been on v12.5.1 since early February and haven't noticed a problem like this. The error you mention seems more like a permission for the ImpUsers role might be somehow missing on the VXS_CUST_MEMBERSHIP view... It would be good to check that if that hasn't been done already.

    We don't have a local view that uses VXS_CUST_MEMBERSHIP specifically, but I just tested our lvs_phone view, which uses vrs_phone_type (which uses ft_control_groups) and it works. I did the test in SSMS, but I used a SQL user setup in the same way as a typical user (i.e. access to ImpUsers role in impresario, but no other elevated permissions) and used ap_set_context so that it ran in the context of one of our user groups. I confirmed that it limited the phone data to only the control groups that Tessitura security group has access to. I also confirmed I was able to select data out of VXS_CUST_MEMBERSHIP.

    I hope that helps.

    Thanks,
    David 

Children
No Data