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.
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
From: Kanani Knudson <bounce-kananiknudson2364@tessituranetwork.com> Sent: 6/11/2013 3:29:01 PM
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!
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