How to restrict Table access in SAP?
- 3 Answers
- 22054 Views
- Infosys, Wipro, I also Faced
- E-Mail Answers
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 to create users?
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?
What are some ap security t codes?
How to assign any program to user?
what is the use of defaults tab in start menu
How to do Role Design, Testing and Implementation
what are the pre-requisites that should be taken before assigning sap_all to a user even there is an approval from authorization controllers?
User is not there in User master record. Then how to trace the user?
What are the steps involved in SAP Security upgradation projects and also in SAP security impletation projects
When would you update a sap table directly? What precautions would you taje?
How we Provided Security design, configuration, and support for SAP Enterprise Portals
What is the maximum number of profiles in a role and maximum number of object in a role?
How to add custon t-code to a role and how to find the auth obj of custom t-code.if the custom t-code doesnt have auth obj, will you save and generate the role?
Explain network topology in sap systems?
What is the use of tmssup* rfc destinations?
