Education & Training
Services & Support
CA Automic Community
to create and rate content, and to follow, bookmark, and share content with other members.
Question asked by
on Sep 2, 2014
on Sep 8, 2014 by Cory_Hankemeier_563
Show 0 Likes
What user groups are allowed to run a job or process flow & how do I find it in the DB browser?
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 2 comments
(Required, will not be published)
Sep 3, 2014 5:36 PM
This query will help you find/summarize all the authorizations that have been granted in your system. The results should look similar to what you would find on the "Authorizations" tab of a User or UserGroup. You can uncomment sections below to help you narrow down specific grants and clients. I hope this helps.
, OH_NAME USER_OR_GRP
, OH_OType as "TYPE"
, UACL_AuthLevel GRP
, UACL_Lnr LINE
, UACL_Filter0 AUTH_TYPE
, UACL_Filter1 OBJECT_TYPE
, UACL_Filter2 OBJECT_NAME
, UACL_Filter3 FT_SEND_HOST
, UACL_Filter5 FT_SEND_USER
, UACL_Filter7 FT_SEND_FILE
, UACL_Filter4 FT_RECV_HOST
, UACL_Filter6 FT_RECV_USER
, UACL_Filter8 FT_RECV_FILE
, decode(bitand(uacl.uacl_bitcode/ 1, 1), 1, 'R', null) as "READ"
, decode(bitand(uacl.uacl_bitcode/ 2, 1), 1, 'W', null) as "WRITE"
, decode(bitand(uacl.uacl_bitcode/ 4, 1), 1, 'X', null) as "EXECUTE"
, decode(bitand(uacl.uacl_bitcode/ 8, 1), 1, 'D', null) as "DELETE"
, decode(bitand(uacl.uacl_bitcode/ 16, 1), 1, 'C', null) as "CANCEL"
, decode(bitand(uacl.uacl_bitcode/ 32, 1), 1, 'S', null) as "STATISTICS"
, decode(bitand(uacl.uacl_bitcode/ 64, 1), 1, 'P', null) as "REPORT"
, decode(bitand(uacl.uacl_bitcode/128, 1), 1, 'M', null) as "MODIFY"
, decode(bitand(uacl.uacl_bitcode/256, 1), 1, 'L', null) as "SLA"
from oh, uacl
where UACL_OH_Idnr = oh_idnr
and OH_DeleteFlag = 0
and OH_OType in ('USER', 'USRG')
-- and oh_client = 100
-- and oh_name IN('JUNK/UC4', 'USRG.JUNK')
order by OH_Client
Show 1 Like
Sep 8, 2014 7:07 PM
Applications Manager doesn't have this information readily available in the database browser.
However we do have a Report that you can run to get this information. The Report is called UC4_ROLES_OBJECTS_BY_USER. This is accessible by navigating to: Object Admin> Development> Reports> select
UC4_ROLES_OBJECTS_BY_USER> Select Show.
You can enter one username or the % symbol to show all users.
Show 1 Like
Retrieving data ...
Dollar Universe running SQL
Changer le port d'une base SQL dans le manager
Appworx Version 9
CA TUESDAY TIPS - EDIT KNOWLEDGE FAILS - KNOWLEDGE PERMISSION GROUPS
Keystore was tampered with, or password was incorrect