• Replies 6 replies
  • Subscribers 338 subscribers
  • Views 44 views
  • Users 0 members are here
Related

Security question

Lisa McColgan
$organization

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

Parents
  • $organization

    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

     

Reply
  • $organization

    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

     

Children
  • $organization in reply to Siobhan Parker (Past Member)
    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

     

    From: Lisa McColgan <bounce-lisamccolgan5409@tessituranetwork.com>
    Sent: 9/1/2009 8:43:12 AM

    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!