Hi everyone -
We have somewhat recently lost our admin, and I have been asked to create a report or list which shows a breakdown of who currently has access to what in Tessitura. I know there's no way to do this in Security. Does someone know of a script or custom report that will allow me to run this information without having to go line-by-line in Security? Thanks.
-Lisa
Lisa,
Siobhan has a great query for the security objects. You can modify or add to this for the different parts in the security module for instance reports, price types, MOS, hold codes and so on. All those tables start with a TX and most have a reference to UserGroup in the table name so you know which table to cross reference.
If you need assistance please let me know I'm more than happy to help write up some scripts for you.
Naomi