Security Report Queries

From KeystoneIntranet
Revision as of 00:02, 10 January 2017 by Intra>User (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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