300+ TOP Sap Security Interview Questions and Answers

Q1. Explain What Things You Have To Take Care Before Executing Run System Trace?

If you are tracing batch user ID or CPIC, then before executing the Run System Trace, you have to ensure that the id should have been assigned to SAP_ALL and SAP_NEW. It enables the user to execute the job without any authorization check failure.

Q2. How To Insert Missing Authorization?

su53 is the best transaction with which we can find the missing authorizations.and we can insert those missing authorization through pfcg.

Q3. How Can I Do A Mass Delete Of The Roles Without Deleting The New Roles?

here is a SAP delivered report that you can copy, remove the system type check and run. To do a landscape with delete, enter the roles to be deleted in a transport, run the delete program or manually delete and then release the transport and import them into all clients and systems.

It is called: AGR_DELETE_ALL_ACTIVITY_GROUPS. To used it, you need to tweak/debug & replace the code as it has a check that ensure it is deleting SAP delivered roles only. Once you get past that little bit, it works well.

Q4. Explain What Is Pfcg_time_dependency?

PFCG_TIME_DEPENDENCY is a report that is used for user master comparison.  It also clears up the expired profiles from user master record. To directly execute this report PFUD transaction code can also be used.

Q5. Mention What Sap Table Can Be Helpful In Determining The Single Role That Is Assigned To A Given Composite Role?

Table AGR_AGRS will be helpful in determining the single role that is assigned to a given composite role.

Q6. What Is The Parameter In Security Audit Log (sm19) That Decides The Number Of Filters?

Parameter rsau/no_of_filters are used to decide the number of filters.

Q7. Which T-code Can Be Used To Delete Old Security Audit Logs?

SM-18 t-code is used to delete the old security audit logs.

Q8. What Is A Composite Role?

A composite role is a container which can collect several different roles. For reasons of clarity, it does not make sense and is therefore not allowed to add composite roles to composite roles. Composite roles are also called roles.
•Composite roles do not contain authorization data. If you want to change the authorizations (that are represented by a composite role), you must maintain the data for each role of the composite role.
•Creating composite roles makes sense if some of your employees need authorizations from several roles. Instead of adding each user separately to each role required, you can set up a composite role and assign the users to that group.
•The users assigned to a composite role are automatically assigned to the corresponding (elementary) roles during comparison.

Q9. Explain What Is Authorization Object And Authorization Object Class?

Authorization Object: Authorization objects are groups of authorization field that regulates particular activity. Authorization relates to a particular action while Authorization field relates for security administrators to configure specific values in that particular action.

Authorization object class: Authorization object falls under authorization object classes, and they are grouped by function area like HR, finance, accounting, etc.

Q10. Mention Which Table Is Used To Store Illegal Passwords?

To store illegal passwords, table USR40 is used, it is used to store pattern of words which cannot be used as a password.

Q11. How Many Transactions Codes Can Be Assigned To A Role?

To a role maximum of 14000 transaction codes can be assigned.

Q12. What Is A Derived Role?

Derived roles refer to roles that already exist. The derived roles inherit the menu structure and the functions included (transactions, reports, Web links, and so on) from the role referenced. A role can only inherit menus and functions if no transaction codes have been assigned to it before.

•The higher-level role passes on its authorizations to the derived role as default values which can be changed afterwards. Organizational level definitions are not passed on. They must be created anew in the inheriting role. User assignments are not passed on either.

•Derived roles are an elegant way of maintaining roles that do not differ in their functionality (identical menus and identical transactions) but have different characteristics with regard to the organizational level.

Q13. Explain How You Can Delete Multiple Roles From Qa, Dev And Production System?

To delete multiple roles from QA, DEV and Production System, you have to follow below steps:

  • Place the roles to be deleted in a transport (in dev)
  • Delete the roles
  • Push the transport through to QA and production
  • This will delete all the all roles

Q14. Explain How You Can Lock All The Users At A Time In Sap?

By executing EWZ5 t-code in SAP, all the user can be locked at the same time in SAP.

Q15. What Is The Different Between Single Role & Composite Role?

A role is a container that collects the transaction and generates the associated profile.  A composite roles is a container which can collect several different roles.

Q16. What Is The Difference Between Usobx_c And Usobt_c?

The table USOBX_C defines which authorization checks are to be performed within a transaction and which not (despite authority-check command programmed ). This table also determines which authorization checks are maintained in the Profile Generator.  The table USOBT_C  defines for each transaction and for each authorization object which default values an authorization created from the authorization object should have in the Profile Generator.

Q17. What Authorization Are Required To Create And Maintain User Master Records?

The following authorization objects are required to create and maintain user master records:

•S_USER_GRP: User Master Maintenance: Assign user groups

•S_USER_PRO: User Master Maintenance: Assign authorization profile

•S_USER_AUT: User Master Maintenance: Create and maintain authorizations

Q18. Someone Has Deleted Users In Our System, And I Am Eager To Find Out Who. Is There A Table Where This Is Logged?

  • Debug or use RSUSR100 to find the info’s.
  • Run transaction SUIM and down its Change documents.

Q19. Mention What Is The Maximum Number Of Profiles In A Role And Maximum Number Of Object In A Role?

Maximum number of profiles in a role is 312, and maximum number of object in a role is 150.

Q20. What Is The T-code Used For Locking The Transaction From Execution?

For locking the transaction from execution t-code SM01, is used.

Q21. Is There A Table For Authorizations Where I Can Quickly See The Values Entered In A Group Of Fields?

In particular I am looking to find the field values for P_ORGIN across a number of authorization profiles, without having to drill down on each profile and authorization. AGR_1251 will give you some reasonable info.[sociallocker]

Q22. Mention What Is The Difference Between Usobt_c And Usobx_c?

USOBT_C: This table consists  the authorization proposal data which contains the authorization data which are relevant for a transaction
USOBX_C: It tells which authorization check are to be executed within a transaction and which must not

Q23. Which Transaction Code Is Used To Display The User Buffer?

User buffer can be displayed by using transaction code AL08.

Q24. Mention What Are The Pre-requisites That Should Be Taken Before Assigning Sap_all To A User Even There Is An Approval From Authorization Controllers?

Pre-requisites follows like

  • Enabling the audit log- using sm 19 tcode
  • Retrieving the audit log- using sm 20 tcode

Q25. Explain What Is Sap Security?

SAP security is providing correct access to business users with respect to their authority or responsibility and giving permission according to their roles.

Q26. What Is The Use Of Role Templates?

User role templates are predefined activity groups in SAP consisting of transactions, reports and web addresses.

Q27. Mention Which T-codes Are Used To See The Summary Of The Authorization Object And Profile Details?

SU03: It gives an overview of an authorization object
SU02: It gives an overview of the profile details

Q28. What Profile Versions?

Profile versions are nothing but when u modifies a profile parameter through a RZ10 and generates a new profile is created with a different version and it is stored in the database.

Q29. Sap Security T-codes?

  • Frequently used security T-codes
  • SU01 Create/ Change User SU01 Create/ Change User
  • PFCG Maintain Roles
  • SU10 Mass Changes
  • SU01D Display User
  • SUIM Reports
  • ST01 Trace
  • SU53 Authorization analysis

Q30. Explain What Reports Or Programs Can Be Used To Regenerate Sap_all Profile?

To regenerate SAP_ALL profile, report AGR_REGENERATE_SAP_ALL can be used.

Q31. Is It Possible To Change Role Template? How?

Yes, we can change a user role template.  There are exactly three ways in which we can work with user role templates

  • we can use it as they are delivered in sap
  • we can modify them as per our needs through pfcg
  • we can create them from scratch.

For all the above specified we have to use pfcg transaction to maintain them.

Q32. Mention Different Tabs Available In Pfcg?

Description: The tab is used to describe the changes made like details related to the role, addition or removal of t-codes, the authorization object, etc.

Menu: It is used for designing user menus like addition of t-codes

Authorization: Used for maintaining authorization data and authorization profile

User: It is used for adjusting user master records and for assigning users to the role.

Q33. Explain What Is Sod In Sap Security?

SOD means Segregation of Duties; it is implemented in SAP in order to detect and prevent error or fraud during the business transaction. For example, if a user or employee has the privilege to access bank account detail and payment run, it might be possible that it can divert vendor payments to his own account.

Q34. Explain What Is User Buffer?

A user buffer consists of all authorizations of a user. User buffer can be executed by t-code SU56 and user has its own user buffer. When the user does not have the necessary authorization or contains too many entries in his user buffer, authorization check fails.

Q35. How To Create Users?

Execute transaction SU01 and fill in all the field. When creating a new user, you must enter an initial password for that user on the Logon data tab. All other data is optional. Click here for tutorial on creating sap user id.

Q36. By Which Parameter Number Of Entries Are Controlled In The User Buffer?

In user buffer number of entries are controlled by the profile parameter “Auth/auth_number_in_userbuffer”.

Q37. Using Which Table Transaction Code Text Can Be Displayed?

Table TSTCT can be used to display transaction code text.

Q38. Mention What Is The Main Difference Between The Derived Role And A Single Role?

For the single role, we can add or delete the t-codes while for a derived role you cannot do that.

Q39. Please Explain The Personalization Tab Within A Role?

Personalization is a way to save information that could be common to users, I meant to a user role…  E.g. you can create SAP queries and manage authorizations by user groups. Now this information can be stored in the personalization tab of the role.  (I supposed that it is a way for SAP to address his ambiguity of its concept of user group and roles: is “usergroup” a grouping of people sharing the same access or is it the role who is the grouping of people sharing the same access).

Q40. What Is The Difference Between Role And A Profile?

Role and profile go hand in hand. Profile is bought in by a role. Role is used as a template,  where you can add T-codes, reports..Profile is one which gives the user authorization.  When you create a role, a profile is automatically created.

Q41. Explain What Does User Compare Do In Sap Security?

In SAP security, USER COMPARE option will compare the user master record so that the produced authorization profile can be entered into the user master record.