Hello,
This is the first of many posts I am sure...
We are in the midst of implementing Tessitura here at Scottish Ballet and have seen the wonderful security object worksheet that was done by Pittsburgh Cultural Trust for V4. Basically, it is a list of all the objects that need to be considered for security in order to decide which user group should have access to what.
I was wondering if anyone would have an updated version of this? This would really help us going through this process quicker!
Many thanks,
Charlotte
Good day, Beth …
I know the pain you described when building a complex list of security rights, etc.
It’s something I started but haven’t had time to review and update.
We also have a quick SQL script that pulls a spreadsheet-type of list of which of our usergroups have what and the description of each. If you'd like a copy of that, let me know...
If you can, would you send me your copy?
We started Tessitura this past July and we’re just now trying to incorporate control & security groups in our organization.
Many Thanks
Wendell Baskin
Bass Hall – Fort Worth
wbaskin@basshall.com
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Gilliland Sent: Thursday, September 12, 2013 13:30 To: Wendell Baskin Subject: Re: [Tessitura Technical Forum] SECURITY SET UP - SECURITY OBJECT WORKSHEET
Hi Charlotte!
Do you mean just a listing of objects with descriptions? You can find them in the online help docs here:
http://www.tessituranetwork.com/Help_System/Content/Security/Table%20of%20Security%20Objects.htm
I remember spending DAYS figuring this out when we first started. Essentially we just went with best guesses and then tweaked as we've gone along. Best of luck!
Beth
From: Charlotte Gross <bounce-charlottegross1066@tessituranetwork.com> Sent: 9/12/2013 10:52:49 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Sure thing, Wendell - I'll send you a copy of our "grid".
This is the SQL we use to pull the data from our system, in case this is helpful for comparison:
select distinct UG_name, c.name, c.description, c.object_id, c.object_type, adding, deleting, editing, viewing from TX_SECURITY_RIGHTS ajoin t_metusergroup b on a.ug_id=b.ug_idjoin t_app_objects c on a.object_id=c.object_id