Hello
We are in the process of auditing Tessitura Security user/groups
Any documents, policy templates, ideas will be very helpful.
-How do you handle cross departmental user's job responsibility via Security group assignment?
-Temporary substitution
-Employee moves to different department
and etc.
I'm interested in Round table at Tessitura conference
Svetlana
Svetlana Mikhalevskaya said:We are in the process of auditing Tessitura Security user/groups
I have commissioned a security group comparison report from Extended Services, which is fantastic for this. You select two or more security groups and then it gives you tabbed options to look at each security area (i.e. reports, security objects, price types, etc.) and you can see how the different groups compare.
Svetlana Mikhalevskaya said:How do you handle cross departmental user's job responsibility via Security group assignment?
Just give them multiple security groups: when they need to do work in a different department they select a different security group for logging in.
Svetlana Mikhalevskaya said:Employee moves to different department
I have a custom table that matches "Locations" from user setup (TR_DEPT in System Tables) to a specific system user, who is considered the "manager" of that department. The idea is that on a routine basis a report is run of all the users in that location and emailed to the "manager", who then confirms that the user list is correct for their department or departments.
Gawain Lavers
Gawain, thanks a lot. you explanation
What is the Extended Service?
It looks like I try to make the similar dataset on backend.
Invent bicycle.
For cross departmental functions we also use multiple group assignment.
The users are not always happy to re-login to work with different area of Tessi.
Thank you for a brilliant idea to provide managers the list of members to review.
I will do the same.
I'm thinking if it makes sense to have a round table on Tessi conference.
Svetlana Mikhalevskaya said:What is the Extended Service?
Extended Services is Tessitura's in-house consulting service. We use them for a number of strategic and technical projects, particularly to supplement my work or build things I'm not prepared to learn how to do. For instance they often build custom reports for us.
Svetlana Mikhalevskaya said:It looks like I try to make the similar dataset on backend.
In the case of our Security Group report, I built the query and then provided it to Extended Services to build a front-end in SSRS. I could send you the stored procedure if you're interested.
Svetlana Mikhalevskaya said:I'm thinking if it makes sense to have a round table on Tessi conference.
On the one hand, Security setup is something everyone struggles with. On the other hand, everyone is so traumatized by it I think they often avoid sessions on the subject...
I'd be interested in seeing the stored procedure you came up with - dlemak@wexarts.org
I ended up running a bunch of separate queries and then creating a matrix in Excel. I can agree with the avoiding the topic due to trauma - I keep looking at this matrix and trying to figure out where to start to right-size our user groups and then promptly find another project to work on.
UserRightsSample.sql
Sample Matrix