• Replies 10 replies
  • Subscribers 338 subscribers
  • Views 139 views
  • Users 0 members are here
Related

SECURITY SET UP - SECURITY OBJECT WORKSHEET

Charlotte Gross
$organization

Hello,

This is the first of many posts I am sure...

We are in the midst of implementing Tessitura here at Scottish Ballet and have seen the wonderful security object worksheet that was done by Pittsburgh Cultural Trust for V4. Basically, it is a list of all the objects that need to be considered for security in order to decide which user group should have access to what.

I was wondering if anyone would have an updated version of this? This would really help us going through this process quicker!

Many thanks,

Charlotte

 

Parents
  • Former Member
    Former Member $organization

    Good day, Beth …

     

    I know the pain you described when building a complex list of security rights, etc.

    It’s something I started but haven’t had time to review and update.

     

    We also have a quick SQL script that pulls a spreadsheet-type of list of which of our usergroups have what and the description of each. If you'd like a copy of that, let me know...

    If you can, would you send me your copy?

    We started Tessitura this past July and we’re just now trying to incorporate control & security groups in our organization.

     

    Many Thanks

    Wendell Baskin

    Bass Hall – Fort Worth

    wbaskin@basshall.com

     

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Gilliland
    Sent: Thursday, September 12, 2013 13:30
    To: Wendell Baskin
    Subject: Re: [Tessitura Technical Forum] SECURITY SET UP - SECURITY OBJECT WORKSHEET

     

    Hi Charlotte!

    Do you mean just a listing of objects with descriptions? You can find them in the online help docs here:

    http://www.tessituranetwork.com/Help_System/Content/Security/Table%20of%20Security%20Objects.htm

    We also have a quick SQL script that pulls a spreadsheet-type of list of which of our usergroups have what and the description of each. If you'd like a copy of that, let me know...

    I remember spending DAYS figuring this out when we first started. Essentially we just went with best guesses and then tweaked as we've gone along. Best of luck!

    Beth

    From: Charlotte Gross <bounce-charlottegross1066@tessituranetwork.com>
    Sent: 9/12/2013 10:52:49 AM

    Hello,

    This is the first of many posts I am sure...

    We are in the midst of implementing Tessitura here at Scottish Ballet and have seen the wonderful security object worksheet that was done by Pittsburgh Cultural Trust for V4. Basically, it is a list of all the objects that need to be considered for security in order to decide which user group should have access to what.

    I was wondering if anyone would have an updated version of this? This would really help us going through this process quicker!

    Many thanks,

    Charlotte

     




    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!

  • $organization in reply to Former Member

    Sure thing, Wendell - I'll send you a copy of our "grid".

    This is the SQL we use to pull the data from our system, in case this is helpful for comparison:

    select distinct UG_name, c.name, c.description, c.object_id, c.object_type, 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

    Beth
Reply
  • $organization in reply to Former Member

    Sure thing, Wendell - I'll send you a copy of our "grid".

    This is the SQL we use to pull the data from our system, in case this is helpful for comparison:

    select distinct UG_name, c.name, c.description, c.object_id, c.object_type, 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

    Beth
Children
No Data