EBS R12中如何查询EBS用户
这篇文章主要介绍了EBS R12中如何查询EBS用户,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。
--R12查询EBS在线用户SQLSELECTU.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_CONNECTFROMICX_SESSIONSICX,FND_USERU,FND_APPLICATIONAPP,FND_APPLICATION_TLFAT,FND_RESPONSIBILITYFR,FND_RESPONSIBILITY_TLFRT,FND_FORM_FUNCTIONSFFF,FND_FORM_FUNCTIONS_TLFFTWHERE1=1ANDU.USER_ID=ICX.USER_IDANDICX.RESPONSIBILITY_APPLICATION_ID=APP.APPLICATION_IDANDFAT.APPLICATION_ID=ICX.RESPONSIBILITY_APPLICATION_IDANDFAT.LANGUAGE='ZHS'ANDFR.APPLICATION_ID=ICX.RESPONSIBILITY_APPLICATION_IDANDFR.RESPONSIBILITY_ID=ICX.RESPONSIBILITY_IDANDFRT.LANGUAGE='ZHS'ANDFRT.APPLICATION_ID=ICX.RESPONSIBILITY_APPLICATION_IDANDFRT.RESPONSIBILITY_ID=ICX.RESPONSIBILITY_IDANDFFF.FUNCTION_ID=ICX.FUNCTION_IDANDFFT.FUNCTION_ID=ICX.FUNCTION_IDANDICX.DISABLED_FLAG!='Y'ANDICX.PSEUDO_FLAG='N'AND(ICX.LAST_CONNECT+DECODE(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),NULL,ICX.LIMIT_TIME,0,ICX.LIMIT_TIME,FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24)>SYSDATEANDICX.COUNTER<ICX.LIMIT_CONNECTS;
SELECTFND.USER_NAME,ICX.RESPONSIBILITY_APPLICATION_ID,ICX.RESPONSIBILITY_ID,FRT.RESPONSIBILITY_NAME,ICX.SESSION_ID,ICX.FIRST_CONNECT,ICX.LAST_CONNECT,DECODE((ICX.DISABLED_FLAG),'N','ACTIVE','Y','INACTIVE')STATUSFROMFND_USERFND,ICX_SESSIONSICX,FND_RESPONSIBILITY_TLFRTWHEREFND.USER_ID=ICX.USER_IDANDICX.RESPONSIBILITY_ID=FRT.RESPONSIBILITY_IDANDICX.DISABLED_FLAG<>'Y'ANDTRUNC(ICX.LAST_CONNECT)=TRUNC(SYSDATE)ORDERBYICX.LAST_CONNECT;
--监控concurrent正在执行的sqlSELECTA.SID,A.SERIAL#,B.SQL_TEXTFROMV$SESSIONA,V$SQLTEXTBWHEREA.SQL_ADDRESS=B.ADDRESSANDA.SID=:P_SIDORDERBYB.PIECE;
--查询某用户一年登录EBS失败的次数:--用apps/apps_password登录:SELECTCOUNT(LOGIN_NAME)FROMFND_UNSUCCESSFUL_LOGINSL,FND_USERUWHEREL.USER_ID=U.CUSTOMER_IDANDATTEMPT_TIME>(SELECTMAX(START_TIME)FROMFND_LOGINSLWHEREL.USER_ID=U.USER_ID)AND(ATTEMPT_TIME+265)>SYSDATEANDU.USER_NAME='<username>';
--查询用户登录次数SELECTPEO.PERSON_ID,PEO.FULL_NAME,FU.USER_ID,FU.USER_NAME,HL.LOCATION_CODE,HL.DESCRIPTION,COUNT(FL.USER_ID)ASLOGIN_TIMESFROMFND_USERFU,PER_ALL_PEOPLE_FPEO,PER_ALL_ASSIGNMENTS_FASS,HR_LOCATIONSHL,FND_LOGINSFLWHEREFU.EMPLOYEE_ID=PEO.PERSON_IDANDASS.PERSON_ID=PEO.PERSON_IDANDASS.LOCATION_ID=HL.LOCATION_IDANDFL.USER_ID(+)=FU.USER_IDANDFU.USER_NAME=:USER_NAMEGROUPBYPEO.PERSON_ID,PEO.FULL_NAME,FU.USER_ID,FU.USER_NAME,HL.LOCATION_CODE,HL.DESCRIPTION;
感谢你能够认真阅读完这篇文章,希望小编分享的“EBS R12中如何查询EBS用户”这篇文章对大家有帮助,同时也希望大家多多支持亿速云,关注亿速云行业资讯频道,更多相关知识等着你来学习!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。