oci_database_autonomous_database_saas_admin_user

This resource provides the Autonomous Database Saas Admin User resource in Oracle Cloud Infrastructure Database service.

This operation updates SaaS administrative user configuration of the Autonomous AI Database.

Example Usage

resource "oci_database_autonomous_database_saas_admin_user" "test_autonomous_database_saas_admin_user" {
	#Required
	autonomous_database_id = oci_database_autonomous_database.test_autonomous_database.id
	password = var.autonomous_database_saas_admin_user_password

	#Optional
	access_type = var.autonomous_database_saas_admin_user_access_type
	duration = var.autonomous_database_saas_admin_user_duration
}

Argument Reference

The following arguments are supported:

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Attributes Reference

The following attributes are exported:

AL32UTF8, AR8ADOS710, AR8ADOS720, AR8APTEC715, AR8ARABICMACS, AR8ASMO8X, AR8ISO8859P6, AR8MSWIN1256, AR8MUSSAD768, AR8NAFITHA711, AR8NAFITHA721, AR8SAKHR706, AR8SAKHR707, AZ8ISO8859P9E, BG8MSWIN, BG8PC437S, BLT8CP921, BLT8ISO8859P13, BLT8MSWIN1257, BLT8PC775, BN8BSCII, CDN8PC863, CEL8ISO8859P14, CL8ISO8859P5, CL8ISOIR111, CL8KOI8R, CL8KOI8U, CL8MACCYRILLICS, CL8MSWIN1251, EE8ISO8859P2, EE8MACCES, EE8MACCROATIANS, EE8MSWIN1250, EE8PC852, EL8DEC, EL8ISO8859P7, EL8MACGREEKS, EL8MSWIN1253, EL8PC437S, EL8PC851, EL8PC869, ET8MSWIN923, HU8ABMOD, HU8CWI2, IN8ISCII, IS8PC861, IW8ISO8859P8, IW8MACHEBREWS, IW8MSWIN1255, IW8PC1507, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, JA16VMS, KO16KSC5601, KO16KSCCS, KO16MSWIN949, LA8ISO6937, LA8PASSPORT, LT8MSWIN921, LT8PC772, LT8PC774, LV8PC1117, LV8PC8LR, LV8RST104090, N8PC865, NE8ISO8859P10, NEE8ISO8859P4, RU8BESTA, RU8PC855, RU8PC866, SE8ISO8859P3, TH8MACTHAIS, TH8TISASCII, TR8DEC, TR8MACTURKISHS, TR8MSWIN1254, TR8PC857, US7ASCII, US8PC437, UTF8, VN8MSWIN1258, VN8VN3, WE8DEC, WE8DG, WE8ISO8859P1, WE8ISO8859P15, WE8ISO8859P9, WE8MACROMAN8S, WE8MSWIN1252, WE8NCR4970, WE8NEXTSTEP, WE8PC850, WE8PC858, WE8PC860, WE8ROMAN8, ZHS16CGB231280, ZHS16GBK, ZHT16BIG5, ZHT16CCDC, ZHT16DBT, ZHT16HKSCS, ZHT16MSWIN950, ZHT32EUC, ZHT32SOPS, ZHT32TRIS

Note: This parameter cannot be used with the ocpuCount parameter. * customer_contacts - Customer Contacts. * email - The email address used by Oracle to send notifications regarding databases and infrastructure. * data_safe_status - Status of the Data Safe registration for this Autonomous AI Database. * data_storage_size_in_gb - The quantity of data in the database, in gigabytes.

For Autonomous AI Transaction Processing databases using ECPUs on Serverless Infrastructure, this value is always populated. In all the other cases, this value will be null and `dataStorageSizeInTBs` will be populated instead.

This may not be updated in parallel with any of the following: licenseModel, databaseEdition, cpuCoreCount, computeCount, dataStorageSizeInTBs, whitelistedIps, openMode, permissionLevel, db-workload, privateEndpointLabel, nsgIds, customerContacts, dbVersion, scheduledOperations, dbToolsDetails, isLocalDataGuardEnabled, or isFreeTier.

Service Change: The default value of the isMTLSConnectionRequired attribute will change from true to false on July 1, 2023 in the following APIs:
* CreateAutonomousDatabase
* GetAutonomousDatabase
* UpdateAutonomousDatabase Details: Prior to the July 1, 2023 change, the isMTLSConnectionRequired attribute default value was true. This applies to Autonomous AI Database Serverless. Does this impact me? If you use or maintain custom scripts or Terraform scripts referencing the CreateAutonomousDatabase, GetAutonomousDatabase, or UpdateAutonomousDatabase APIs, you want to check, and possibly modify, the scripts for the changed default value of the attribute. Should you choose not to leave your scripts unchanged, the API calls containing this attribute will continue to work, but the default value will switch from true to false. How do I make this change? Using either Oracle Cloud Infrastructure SDKs or command line tools, update your custom scripts to explicitly set the isMTLSConnectionRequired attribute to true.

This cannot be updated in parallel with any of the following: cpuCoreCount, computeCount, dataStorageSizeInTBs, adminPassword, isMTLSConnectionRequired, dbWorkload, privateEndpointLabel, nsgIds, dbVersion, dbName, scheduledOperations, dbToolsDetails, or isFreeTier. * lifecycle_details - Information about the current lifecycle state. * local_adg_auto_failover_max_data_loss_limit - Parameter that allows users to select an acceptable maximum data loss limit in seconds, up to which Automatic Failover will be triggered when necessary for a Local Autonomous Data Guard * local_disaster_recovery_type - Indicates the local disaster recovery (DR) type of the Autonomous AI Database Serverless instance. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover. * local_standby_db - Autonomous Data Guard standby database details. * availability_domain - The availability domain of a local Autonomous Data Guard standby database of an Autonomous AI Database Serverless instance. * lag_time_in_seconds - The amount of time, in seconds, that the data of the standby database lags the data of the primary database. Can be used to determine the potential data loss in the event of a failover. * lifecycle_details - Additional information about the current lifecycle state. * maintenance_target_component - The component chosen for maintenance. * state - The current state of the Autonomous AI Database. * time_data_guard_role_changed - The date and time the Autonomous Data Guard role was switched for the standby Autonomous AI Database. * time_disaster_recovery_role_changed - The date and time the Disaster Recovery role was switched for the standby Autonomous AI Database. * time_maintenance_begin - The date and time when maintenance will begin. * time_maintenance_end - The date and time when maintenance will end. * long_term_backup_schedule - Details for the long-term backup schedule. * is_disabled - Indicates if the long-term backup schedule should be deleted. The default value is FALSE. * repeat_cadence - The frequency of the long-term backup schedule * retention_period_in_days - Retention period, in days, for long-term backups * time_of_backup - The timestamp for the long-term backup schedule. For a MONTHLY cadence, months having fewer days than the provided date will have the backup taken on the last day of that month. * maintenance_target_component - The component chosen for maintenance. * memory_per_compute_unit_in_gbs - The amount of memory (in GBs) to be enabled per OCPU or ECPU. * memory_per_oracle_compute_unit_in_gbs - The amount of memory (in GBs, rounded off to nearest integer value) to be enabled per OCPU or ECPU. This is deprecated. Please refer to memoryPerComputeUnitInGBs for accurate value. * ncharacter_set - The national character set for the Autonomous AI Database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8. * net_services_architecture - Enabling SHARED server architecture enables a database server to allow many client processes to share very few server processes, thereby increasing the number of supported users. * next_long_term_backup_time_stamp - The date and time when the next long-term backup would be created. * nsg_ids - The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions: * A network security group (NSG) is optional for Autonomous AI Databases with private access. The nsgIds list can be empty. * ocpu_count - The number of OCPU cores to be made available to the database.

The following points apply:
* For Autonomous AI Databases on Dedicated Exadata Infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous AI Database Serverless instances.)
* To provision cores, enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous AI Databases on both serverless and dedicated Exadata infrastructure.
* For Autonomous AI Database Serverless instances, this parameter is not used.

For Autonomous AI Databases on Dedicated Exadata Infrastructure, the maximum number of cores is determined by the infrastructure shape. See [Characteristics of Infrastructure Shapes](https://docs.oracle.com/en/cloud/paas/autonomous-database/dedicated/adbde/index.html) for shape details.

**Note:** This parameter cannot be used with the `cpuCoreCount` parameter.

This cannot be updated in parallel with any of the following: cpuCoreCount, computeCount, computeModel, adminPassword, whitelistedIps, isMTLSConnectionRequired, nsgIds, dbVersion, isRefreshable, dbName, scheduledOperations, dbToolsDetails, or isFreeTier. * private_endpoint - The private endpoint for the resource. * private_endpoint_ip - The private endpoint Ip address for the resource. * private_endpoint_label - The resource’s private endpoint label. * Setting the endpoint label to a non-empty string creates a private endpoint database. * Resetting the endpoint label to an empty string, after the creation of the private endpoint database, changes the private endpoint database to a public endpoint database. * Setting the endpoint label to a non-empty string value, updates to a new private endpoint database, when the database is disabled and re-enabled.

This setting cannot be updated in parallel with any of the following: licenseModel, dbEdition, cpuCoreCount, computeCount, computeModel, adminPassword, whitelistedIps, isMTLSConnectionRequired, dbWorkload, dbVersion, isRefreshable, dbName, scheduledOperations, dbToolsDetails, or isFreeTier.

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

This cannot be updated in parallel with any of the following: licenseModel, dbEdition, cpuCoreCount, computeCount, computeModel, adminPassword, isMTLSConnectionRequired, openMode, permissionLevel, dbWorkload, dbVersion, isRefreshable, dbName, scheduledOperations, dbToolsDetails, isLocalDataGuardEnabled, or isFreeTier.

These subnets are used by the Oracle Clusterware private interconnect on the database instance. Specifying an overlapping subnet will cause the private interconnect to malfunction. This restriction applies to both the client subnet and the backup subnet. * subscription_id - The OCID of the subscription with which resource needs to be associated with. * supported_regions_to_clone_to - The list of regions that support the creation of an Autonomous AI Database clone or an Autonomous Data Guard standby database. * system_tags - System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. * time_created - The date and time the Autonomous AI Database was created. * time_data_guard_role_changed - The date and time the Autonomous Data Guard role was switched for the Autonomous AI Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the “primary” role in the primary Data Guard region, or database located in the remote Data Guard standby region. * time_deletion_of_free_autonomous_database - The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted. * time_disaster_recovery_role_changed - The date and time the Disaster Recovery role was switched for the standby Autonomous AI Database. * time_earliest_available_db_version_upgrade - The earliest(min) date and time the Autonomous AI Database can be scheduled to upgrade to 26ai. * time_latest_available_db_version_upgrade - The max date and time the Autonomous AI Database can be scheduled to upgrade to 26ai. * time_local_data_guard_enabled - The date and time that Autonomous Data Guard was enabled for an Autonomous AI Database where the standby was provisioned in the same region as the primary database. * time_maintenance_begin - The date and time when maintenance will begin. * time_maintenance_end - The date and time when maintenance will end. * time_of_auto_refresh_start - The the date and time that auto-refreshing will begin for an Autonomous AI Database refreshable clone. This value controls only the start time for the first refresh operation. Subsequent (ongoing) refresh operations have start times controlled by the value of the autoRefreshFrequencyInSeconds parameter. * time_of_joining_resource_pool - The time the member joined the resource pool. * time_of_last_failover - The timestamp of the last failover operation. * time_of_last_refresh - The date and time when last refresh happened. * time_of_last_refresh_point - The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh. * time_of_last_switchover - The timestamp of the last switchover operation for the Autonomous AI Database. * time_of_next_refresh - The date and time of next refresh. * time_reclamation_of_free_autonomous_database - The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state. * time_scheduled_db_version_upgrade - The date and time the Autonomous AI Database scheduled to upgrade to 26ai. * time_undeleted - The date and time the Autonomous AI Database was most recently undeleted. * time_until_reconnect_clone_enabled - The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database. * total_backup_storage_size_in_gbs - The backup storage to the database. * used_data_storage_size_in_gbs - The storage space consumed by Autonomous AI Database in GBs. * used_data_storage_size_in_tbs - The amount of storage that has been used for Autonomous AI Databases in dedicated infrastructure, in terabytes. * vault_id - The OCID of the Oracle Cloud Infrastructure vault. This parameter and secretId are required for Customer Managed Keys. * whitelisted_ips - The client IP access control list (ACL). This feature is available for Autonomous AI Database Serverless and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous AI Database instance. If arePrimaryWhitelistedIpsUsed is ‘TRUE’ then Autonomous AI Database uses this primary’s IP access control list (ACL) for the disaster recovery peer called standbywhitelistedips.

For Autonomous AI Database Serverless, this is an array of CIDR (classless inter-domain routing) notations for a subnet or VCN OCID (virtual cloud network Oracle Cloud ID). Multiple IPs and VCN OCIDs should be separate strings separated by commas, but if it’s other configurations that need multiple pieces of information then its each piece is connected with semicolon (;) as a delimiter. Example: `["1.1.1.1","1.1.1.0/24","ocid1.vcn.oc1.sea.<unique_id>","ocid1.vcn.oc1.sea.<unique_id1>;1.1.1.1","ocid1.vcn.oc1.sea.<unique_id2>;1.1.0.0/16"]` For Exadata Cloud@Customer, this is an array of IP addresses or CIDR notations. Example: `["1.1.1.1","1.1.1.0/24","1.1.2.25"]`

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

This cannot be updated in parallel with any of the following: licenseModel, dbEdition, cpuCoreCount, computeCount, computeModel, adminPassword, isMTLSConnectionRequired, openMode, permissionLevel, dbWorkload, dbVersion, isRefreshable, dbName, scheduledOperations, dbToolsDetails, isLocalDataGuardEnabled, or isFreeTier.

Timeouts

The timeouts block allows you to specify timeouts for certain operations: * create - (Defaults to 20 minutes), when creating the Autonomous Database Saas Admin User * update - (Defaults to 20 minutes), when updating the Autonomous Database Saas Admin User * delete - (Defaults to 20 minutes), when destroying the Autonomous Database Saas Admin User

Import

Import is not supported for this resource.