2010年12月23日

SAP权限查询(事务码)

摘要: SELECT distinct B.AGR_NAME,B.UNAME,right(B.UNAME,6) as xuhao,A.TCODEFROM AGR_TCODES AS A INNER JOIN AGR_USERS AS BON A.AGR_NAME = B.AGR_NAME INNER JOIN V_USERNAME AS CON B.UNAME = C.BNAMEwhere B.UNAME like '%***%'ORDER BY B.UNAME,A.TCODE 阅读全文

posted @ 2010-12-23 14:13 愚工养码 阅读(802) 评论(0) 推荐(0) 编辑

锁住了最高权限的用户,怎么解开?

摘要: 表名:USR02解锁语句:update USR02 set uflag=0 where bname='username' and mandt=*** 阅读全文

posted @ 2010-12-23 14:10 愚工养码 阅读(166) 评论(0) 推荐(0) 编辑

导航