View source for Security - Options by Users Query / Report

<PRE>
select USER_GROUP_ID "User",OPTION_NAME "Option Name",OPTION_VALUE "Option Value",LAST_CHANGE_DATETIME "Last Changed",Last_change_user "Last Change User" from cctoptn
where option_name in 
('GLSYSTEM','CMSYSTEM','ARSYSTEM','APSYSTEM','PRSYSTEM','DATASCOPE','INVENTORYACTIVE','TISYSTEM')
order by user_group_id,option_name
</PRE>
or
<PRE>
select user_group_id,
(select sum(option_value) from cctoptn c2
     where c2.option_name='ARSYSTEM' and c2.user_group_id=c1.user_group_id) AR,
(select sum(option_value) from cctoptn c2
     where c2.option_name='APSYSTEM' and c2.user_group_id=c1.user_group_id) AP,
(select sum(option_value) from cctoptn c2
     where c2.option_name='GLSYSTEM' and c2.user_group_id=c1.user_group_id) GL,
(select sum(option_value) from cctoptn c2
     where c2.option_name='PRSYSTEM' and c2.user_group_id=c1.user_group_id) Payroll,
(select sum(option_value) from cctoptn c2
     where c2.option_name='CMSYSTEM' and c2.user_group_id=c1.user_group_id) Cash_Mgt,
(select sum(option_value) from cctoptn c2
     where c2.option_name='QYSYSTEM' and c2.user_group_id=c1.user_group_id) Quoting,
(select sum(option_value) from cctoptn c2
     where c2.option_name='TISYSTEM' and c2.user_group_id=c1.user_group_id) Ticketing
from cctoptn c1
group by user_group_id
order by user_group_id
</PRE>