Oracle supported attributes
The following table describes the supported attributes when configuring provisioning for Oracle.
Supported attributes
| Attribute name | Description | Mapped ISV attribute (Default mapping) | Type | Mandatory | Modifiable |
|---|---|---|---|---|---|
| erPassword | The password for the Oracle user. | Password generated by ISV | String | No | No, we do not allow you to modify password when using ISV. |
| erUid | The login name of the Oracle user. | preferred_username | String | Yes | No |
| erAccountStatus | The status of the account either enabled or unavailable. | Active | Boolean | No | Yes |
| erOraSysPriv | The System Privilege assigned to the user. | Permissions of type SysPriv | String | No | Yes |
| erOraDefaultTableSpace | The name of the default table space. | String | No | Yes | |
| erOraTemporaryTableSpace | The name of the temporary table space. | String | No | Yes | |
| erOraTblSpcQuota | The maximum space allowed on a table space. | String | No | Yes | |
| erOraAuthenticationType | Specifies how the user is authenticated by Oracle. | Canonical values - LOCAL, GLOBAL, EXTERNAL | Yes | Yes | |
| erOraGlobalName | An external name that identifies the user. | String | Yes, if erOraAuthenticationType is GLOBAL. | No | |
| erOraRole | The database roles assigned as default roles to the account. | String | No | Yes | |
| erOraNonDefRole | The database roles assigned as non-default roles (for example, password protected roles) to the account. | String | No | Yes | |
| erOraProfile | The profile name assigned to the account. | String | No | Yes | |
| erOraExpirePwd | If true, set the password to expire. | Boolean | No | Yes | |
| erOraProxyUsers | The proxy user for this user. | String | No | Yes | |
| erOraRsrcConsumerGroup | The consumer group that a user can switch to. | String | No | Yes | |
| erOraDefRsrcConsumerGroup | The default or initial resource consumer group for a user. | String | No | Yes | |
| If this attribute is not assigned a value, the default value, DEFAULT_CONSUMER_GROUP, is used. | |||||
| This attribute can have either the preceding default value or some value from the resource consumer group list that is allowed for the user (though resource consumer group is multivalued attribute). Assigning any value outside this list will result in error on the resource. | |||||
| The erOraRsrcConsumerGroup and erOraDefRsrcConsumerGroup must have the same value. | |||||
| erOraExpiryDate | The expiry date of an Oracle account. | String | No | No | |
| erOraCreateDate | The creation date of an Oracle account. | String | No | No | |
| erOraLockDate | The lock date of an Oracle account. | String | No | No | |
| erOraAccountStatusstr | The account status of an Oracle account. | String | No | No |