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.
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
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