Access Profiles

An access profile is the set of security permissions that determines what data a user can access.

The following table describes the Oracle Migration Tool On Demand client commands that are used with access profiles. The commands are case sensitive. For examples of running these commands, see Migrating Access Profiles.

Table Oracle Migration Tool On Demand Commands for Access Profiles

Command Description

Command	Description
`[-sortspec "AccessObjectName[ sortorder]"] Read AccessProfile SystemNameOfAccessProfile`	This command exports a single access profile from an Oracle CRM On Demand server. The optional `sortspec` parameter allows you to sort the access objects by access object name. The supported values for sortorder are: ASC for sorting in ascending order. DESC for sorting in descending order. If you specify AccessObjectName but you do not specify the sort order, then the access objects are sorted in ascending order by default. If you do not specify AccessObjectName, then the access objects are listed in no specific order.
`[-sortspec "AccessObjectName[ sortorder]"] ReadAll AccessProfile [FolderLocation]`	This command exports all access profiles from an Oracle CRM On Demand server. For information about the optional `sortspec` parameter, see the description of the `Read` command.
`Upsert AccessProfile AccessProfileXML`	This command updates or inserts a single access profile on an Oracle CRM On Demand server, as required.

[-sortspec "AccessObjectName[ sortorder]"] Read AccessProfile SystemNameOfAccessProfile

This command exports a single access profile from an Oracle CRM On Demand server.

The optional sortspec parameter allows you to sort the access objects by access object name.

The supported values for sortorder are:

ASC for sorting in ascending order.
DESC for sorting in descending order.

If you specify AccessObjectName but you do not specify the sort order, then the access objects are sorted in ascending order by default.

If you do not specify AccessObjectName, then the access objects are listed in no specific order.

[-sortspec "AccessObjectName[ sortorder]"] ReadAll AccessProfile [FolderLocation]

This command exports all access profiles from an Oracle CRM On Demand server.

For information about the optional sortspec parameter, see the description of the Read command.

Upsert AccessProfile AccessProfileXML

This command updates or inserts a single access profile on an Oracle CRM On Demand server, as required.

Note: Do not assume that the system name of the access profile is the same as what you see in the user interface for Oracle CRM On Demand. For example, if you create an access profile called My Access Profile and later rename it to My Renamed Access Profile, then the system name continues to be My Access Profile. Therefore, if you want to read this specific access profile, then you must reference it by the name, My Access Profile, in your read request. The only way to determine the real name of an access profile that has been modified is to perform a ReadAll operation and export all the configuration data.