Security question

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
  • Thank you so much, Jonathan. That solved my problem.

     

    Susan P. Ashcraft

    Box Office Manager

    Sarasota Opera

    61 N. Pineapple Avenue

    Sarasota, FL   34236

    941-366-8450 Ext. 227

    sashcraft@sarasotaopera.org


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jonathan Smillie
    Sent: Monday, July 09, 2012 2:58 PM
    To: Susan Ashcraft
    Subject: Re: [Tessitura Technical Forum] Security Question

     

    Hi Susan,


    Giving access to the security object for System Tables only gives access to the module itself. You have to go into the security settings for the group he belongs to and assign which tables (such as TR_INV_CONTENT) he can then look at- just like price types, MOS, reports etc.. By default he doesn't have access to any of them,  hence the blank screen.

    Hope this helps!

    Jonathan

    From: Susan Ashcraft <bounce-susanashcraft3988@tessituranetwork.com>
    Sent: 7/9/2012 1:18:45 PM

    I am trying to give our Marketing Director temporary access to System Tables, specifically TR_INV_CONTENT.

    Is another Security Object related to it? I've tried everything I know and all he can see is a blank table.

    I appreciate all input on this!

    Thanks,

    Susan




    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!

Reply
  • Thank you so much, Jonathan. That solved my problem.

     

    Susan P. Ashcraft

    Box Office Manager

    Sarasota Opera

    61 N. Pineapple Avenue

    Sarasota, FL   34236

    941-366-8450 Ext. 227

    sashcraft@sarasotaopera.org


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jonathan Smillie
    Sent: Monday, July 09, 2012 2:58 PM
    To: Susan Ashcraft
    Subject: Re: [Tessitura Technical Forum] Security Question

     

    Hi Susan,


    Giving access to the security object for System Tables only gives access to the module itself. You have to go into the security settings for the group he belongs to and assign which tables (such as TR_INV_CONTENT) he can then look at- just like price types, MOS, reports etc.. By default he doesn't have access to any of them,  hence the blank screen.

    Hope this helps!

    Jonathan

    From: Susan Ashcraft <bounce-susanashcraft3988@tessituranetwork.com>
    Sent: 7/9/2012 1:18:45 PM

    I am trying to give our Marketing Director temporary access to System Tables, specifically TR_INV_CONTENT.

    Is another Security Object related to it? I've tried everything I know and all he can see is a blank table.

    I appreciate all input on this!

    Thanks,

    Susan




    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!

Children
No Data