—Oracle sql script to determine the access groups and trees a user has access to
select DISTINCT A.ACCESS_GROUP,A.TREE_NAME, B.OPRCLASS FROM PS_SCRTY_ACC_GRP A, PSOPRCLS B WHERE OPRID = ‘YourOPRID’ AND A.CLASSID = B.OPRCLASS
Query security script
最新推荐文章于 2024-09-25 10:31:05 发布