How to reset SAP* password from oracle database.

Q. How to reset SAP* password from oracle database.

A. Logon to your database with orasid as user id and run this sqldelete from sapSID.usr02

where bname='SAP*' and mandt='XXX';commit;

Where mandt is the client.

Now you can login to the client using sap* and password pass

Can you add a composite role to another composite role?

Q. Can you add a composite role to another composite role?

A. No

How many profiles can be assigned to any user master record.

Q. How many profiles can be assigned to any user master record.

A. Maximum Profiles that can be assigned to any user is ~ 312. Table USR04 (Profile assignments for users). This table contains both information on the change status of a user and also the list of the profile names that were assigned to the user.

The field PROFS is used for saving the change flag (C = user was created, M = user was changed), and the name of the profiles assigned to the user. The field is defined with a length of 3750 characters. Since the first two characters are intended for the change flag, 3748 characters remain for the list of the profile names per user. Because of the maximum length of 12 characters per profile name, this results in a maximum number of 312 profiles per user.

Can we convert Authorization field to Org, field

Q. Can we convert Authorization field to Org, field

A. Authorization field can be changed to Organization field using PFCG_ORGFIELD_CREATE or ZPFCG_ORGFIELD_CREATEUse SE38 or SA38 to run the above report.

* Organizational level fields should only be created before you start setting up your system. If you create organizational level fields later, you might have to do an impact analysis. The authentication data may have to be postprocessed in roles.

* The fields "Activity", "ACTVT" and "Transaction code", "TCD" cannot be converted into an organizational level field.

In addition, all affected roles are analyzed and the authorization data is adjusted. The values of the authorization field which is now to become the organizational level field are removed and entered into the organizational level data of the role.

Note: Table for Org Element- USORGRefer to Note 323817 for more detail.

Q. What are the different tabs in PFCG?

What does the different color light mean in profile generator?

What is a composite role?

Q 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.

Follow the link to learn more