Some User has made changes to Tables in SAP. How to identify that user?
Answer Posted / sapsecvj
A little BG: If I create a role using PFCG, there are at least 2-3 tables been updated, eg: AGR_TEXTS, AGR_125 even though I do not have S_TABU_DIS & S_TABU_NAM.
Majority of the business transactions will be updating the tables in the back-end. We need to know on which date, which Tcode is used and which table is been updated by the user.
Method 1:
Go to ST03N and trace out who used the Tcode on the particular date.
Method 2:
Use FM CHANGE_DOCUMENTS_READ (dont have access to SAP, pls check name). Pass appropriate Values to the FM. it will return results from CDHDR, CDPOS tables. this is also the fastest way to access them.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is centralize FFID?
DOES ANYONE KNOW WHAT TYPES OF SECURITY QUESTIONS ACCENTURE ASKED IN USA....URGENT PLEASE
Giving fire call access and extending fire call access by using VIRSA’s VFAT tool.can any one brief this
What are su56 t-codes used for?
What appears as the last sentence in sap note 587410?
Is it possible to change role template? How?
What authorization is required to create and maintain user master records?
Can you anybody tell me what are the questions frequently asked 3 years of SAP Security experienced level in INFOSYS company.
what is hypercare and go live support?
What does the item category specify in a purchasing order in SAP Materials Management?
what is user buffer?
What does the account assessment category specify in a purchasing order in SAP Materials Management?
Any details about secatt apart from SAPSecurity online.com?
how we Designed security solution for FI, FM, MM, QM, PM, PS, HR (Time Entry, Travel) modules
1) Explain different type of Users? Explain specifically Service User? 2) Difference between System and Communication User?Explain in Context of Profile Parameter? 3) There are 5 systems say BI, SOLMAN, CRM, PI, SRM etc etc. Which system will act as a satellite system in CUA and Why? HOw CUa system works? 4) State different types of Transactions & Tables in Strutural Authorization Profile in HR Security? 5) What is L0 , L1 , L2 , L3 , L4 code called in HR Security? 6) What fields are required to create Strutural Authorization Profile in HR Security? State significance of Evaluation Path? 7) What is Structural Authorization Profile in HR Security? When required Role has already been assigned to User then why Structural Authorization Profile is required by user? 8) How are structural Authorization Profile are created? 9) Important Authorization Object in HR Security? 10) Fields in P_ORGIN A.O? 11) Important infotypes and What is PA? 12) How access is provided for tables to user? Significance of Authorization Group in TDDAT table? 13) Difference between SU22 and SU24? 14) Explain Authorization Structure? 15) Which table stores the Authorization Object of a User? 16) What we do to keep Roles consistent in DEV QAS and PRD? 17) A User has create and display access? Will he have access to change as well? 18) How User can have access to view salary slip of other employees(HR Security)?Explain in detail. 19) In HR security does we add Employee ID anywhere in Roles? 20) Any issue you have faced while Transport? 21) Have you faced any issue in Upgrade? Expalain how to compare Roles from older version of SAP to new version of SAP? 22) Any typical issue you have resolved in HR Security?