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
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.
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.
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