Security question

Beauty!  That did it!  Thanks so much!

 

-Lisa

 

Lisa D. McColgan
Huntington Theatre Company
Office of Development
264 Huntington Avenue
Boston, MA  02115-4606
(617) 273-1546

>>> bounce-siobhanbennetts3867@tessituranetwork.com 9/1/2009 10:01 AM >>>

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

 

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

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!

Beauty!  That did it!  Thanks so much!

 

-Lisa

 

Lisa D. McColgan
Huntington Theatre Company
Office of Development
264 Huntington Avenue
Boston, MA  02115-4606
(617) 273-1546

>>> bounce-siobhanbennetts3867@tessituranetwork.com 9/1/2009 10:01 AM >>>

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

 

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

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!