Tessitura Security Audit

Hi Kanani,

There are some shared reports that can help with this. We used #78 in the Shared Reports workspace on TASK. If you search for security, you will find that one along with some others.

Thanks,

David

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kanani Knudson
Sent: Tuesday, June 11, 2013 1:40 PM
To: David Frederick
Subject: [Tessitura Technical Forum] Tessitura Security Audit

Hi All,

I am looking for a report or maybe a SQL query that will give me the contents of our Tessitura Security Set-up.  We are being audited this week and I need to provide information about the rights given for each security group.  I thought a report would exist within the Tessitura Security Module, but I can't seem to find one.

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!

Thanks, all.  I think I’ll go with Natasha’s method since this is something we only need about once a year.  Thanks for the query, Natasha!

Kanani Knudson| Sales and Database Coordinator | (206) 443-0807 x1206| Ticket Office: (206) 441-3322
Seattle Children's Theatre |www.sct.org| 201 Thomas St. Seattle WA, 98109

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Natasha Purkiss
Sent: Tuesday, June 11, 2013 2:12 PM
To: Kanani Knudson
Subject: Re: [Tessitura Technical Forum] Tessitura Security Audit

Hi Kanani,

For a quick and dirty query, I often run the following to compare user rights between user groups. 

It could be very easily adjusted to get the rights of all user groups. This one is comparing Development to House Management.

Select * 

from TX_SECURITY_RIGHTS a

join T_APP_OBJECTS b on a.object_id=b.object_id

where 

UG_id like 'DEV' 

and a.object_id not in 

(

select object_id 

from TX_SECURITY_RIGHTS 

where UG_id like 'House'

)

and (adding <> 'N' or deleting <> 'N' or editing <> 'N' or viewing <> 'N')

Hope that helps, 

Natasha

Hi Adria,

If you just need to audit one user, you should be able to do so from the Tessitura Security module (if you haven’t heard of this before, it is a separate program from Tessitura).  This query was done in SQL Server Management Studio.  I actually ended up using a report that Heather Kraft from the Seattle Rep shared with me, instead of the query listed below.  If you don’t have access to Tessitura Security, this might be the best route for you.  Although you may need special access to install a shared report if you haven’t done that before.

Kanani Knudson| Sales and Database Coordinator | (206) 443-0807 x1206| Ticket Office: (206) 441-3322
Seattle Children's Theatre |www.sct.org| 201 Thomas St. Seattle WA, 98109

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Adria Gunter
Sent: Monday, February 03, 2014 10:38 AM
To: Kanani Knudson
Subject: RE: [Tessitura Technical Forum] Tessitura Security Audit

Where exactly are you guys doing your queries? What are you using? I need instructions like a four year old and a couple of details were missed here. I need to audit a user and I'd like to find a quick way to do it in Tessitura. 

Thanks. 

Adria