Security Report Queries

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

select security_class "Sec Class",
user_id "User Override",
Section_Name "Sec Section",group_name "Sec Group",Option_name "Sec Group" from cctsectl
order by security_class,section_name