How to restrict Table access in SAP?
Answer Posted / manoj
we can restrict table by using authorization objects :
1)S_TABU_DIS: restrict at authorization group level (ex:sa sc, &nc& etc)
2)S_TABU_NAM: restrict at table level(ex:usr40,usr01,agr_define etc)
@To check weather table belongs to which authorization group(goto table TTDAT(SE16/SE16N)....
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can I do a mass delete of the roles without deleting the new roles?
Can you explain protecting public keys?
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?
Why is it important to delete sap-new profile? What steps will you take to do this?
What is t code?
Can you explain internet-level security?
Please let me know if there any vacancies for 3 years of Experienced level in SAP Security
Explain secure store and forward?
How to insert missing authorization?
When would you update a sap table directly?
What is a composite role?
what is the process to find that one consultant had removed a table from sap tables
can you please send me SAP Security upgrade documents and guide for CRM 5 and CRM 7 and what are the differeces between crm 5 AND crm 7 according to sap security point of view.
How to codify for an Item in SAP? How many digits are required for an item?
What is audit information system?