EBS R12 查询EBS用户相关SQL

最新推荐文章于 2023-12-13 16:10:29 发布

夜满青山

最新推荐文章于 2023-12-13 16:10:29 发布

阅读量386

点赞数

分类专栏： Oracle EBS DBA

本文链接：https://blog.csdn.net/thostec/article/details/84982365

版权

本文详细介绍了如何在Oracle EBS R12系统中，通过SQL查询来获取用户的相关信息，包括登录名、权限、角色等，帮助系统管理员更好地管理和监控EBS用户。

摘要由CSDN通过智能技术生成

--R12查询EBS在线用户SQL 
SELECT U.USER_NAME,
       APP.APPLICATION_SHORT_NAME,
       FAT.APPLICATION_NAME,
       FR.RESPONSIBILITY_KEY,
       FRT.RESPONSIBILITY_NAME,
       FFF.FUNCTION_NAME,
       FFT.USER_FUNCTION_NAME,
       ICX.FUNCTION_TYPE,
       ICX.FIRST_CONNECT,
       ICX.LAST_CONNECT
  FROM ICX_SESSIONS ICX,
       FND_USER U,
       FND_APPLICATION APP,
       FND_APPLICATION_TL FAT,
       FND_RESPONSIBILITY FR,
       FND_RESPONSIBILITY_TL FRT,
       FND_FORM_FUNCTIONS FFF,
       FND_FORM_FUNCTIONS_TL FFT
WHERE     1 = 1
       AND U.USER_ID = ICX.USER_ID
       AND ICX.RESPONSIBILITY_APPLICATION_ID = APP.APPLICATION_ID
       AND FAT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID
       AND FAT.LANGUAGE = 'ZHS'
       AND FR.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID
       AND FR.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID
       AND FRT.LANGUAGE = 'ZHS'
       AND