Security question

Hi

The table that contains the raw data is TX_SECURITY_RIGHTS, you can write a script in conjunction with T_METUSERGROUP and T_APP_OBJECTS to see which group has access to what.

I use the following:

select distinct UG_name, c.name, d.description, adding, deleting, editing, viewing from tx_security_rights a
join t_metusergroup b on a.ug_id=b.ug_id
join t_app_objects c on a.object_id=c.object_id
left outer join tr_constituency d on a.constituency=d.id

Hope that helps

Siobhan

There are some shared reports that will do this for you. I believe they are from the BSO.

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