Oracle Cloud Infrastructure
CloudDatabaseManagement
This resource provides the Database Management resource in Oracle Cloud Infrastructure Database service.
Enable / Update / Disable database management for the specified Oracle Database instance.
Database Management requires USER_NAME, PASSWORD_SECRET_ID and PRIVATE_END_POINT_ID.
database.0.database_management_config is updated to appropriate managementType and managementStatus for the specified Oracle Database instance.
Example Usage
using System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var test = new Oci.Database.CloudDatabaseManagement("test", new()
{
DatabaseId = oci_database_database.Test_database.Id,
ManagementType = @var.Database_cloud_database_management_details_management_type,
PrivateEndPointId = @var.Database_cloud_database_management_details_private_end_point_id,
ServiceName = @var.Database_cloud_database_management_details_service_name,
Credentialdetails = new Oci.Database.Inputs.CloudDatabaseManagementCredentialdetailsArgs
{
UserName = @var.Database_cloud_database_management_details_user_name,
PasswordSecretId = @var.Database_cloud_database_management_details_password_secret_id,
},
EnableManagement = @var.Database_cloud_database_management_details_enable_management,
Port = @var.Cloud_database_management_port,
Protocol = @var.Cloud_database_management_protocol,
Role = @var.Cloud_database_management_role,
SslSecretId = oci_vault_secret.Test_secret.Id,
});
});
package main
import (
"github.com/pulumi/pulumi-oci/sdk/go/oci/Database"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := Database.NewCloudDatabaseManagement(ctx, "test", &Database.CloudDatabaseManagementArgs{
DatabaseId: pulumi.Any(oci_database_database.Test_database.Id),
ManagementType: pulumi.Any(_var.Database_cloud_database_management_details_management_type),
PrivateEndPointId: pulumi.Any(_var.Database_cloud_database_management_details_private_end_point_id),
ServiceName: pulumi.Any(_var.Database_cloud_database_management_details_service_name),
Credentialdetails: &database.CloudDatabaseManagementCredentialdetailsArgs{
UserName: pulumi.Any(_var.Database_cloud_database_management_details_user_name),
PasswordSecretId: pulumi.Any(_var.Database_cloud_database_management_details_password_secret_id),
},
EnableManagement: pulumi.Any(_var.Database_cloud_database_management_details_enable_management),
Port: pulumi.Any(_var.Cloud_database_management_port),
Protocol: pulumi.Any(_var.Cloud_database_management_protocol),
Role: pulumi.Any(_var.Cloud_database_management_role),
SslSecretId: pulumi.Any(oci_vault_secret.Test_secret.Id),
})
if err != nil {
return err
}
return nil
})
}
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Database.CloudDatabaseManagement;
import com.pulumi.oci.Database.CloudDatabaseManagementArgs;
import com.pulumi.oci.Database.inputs.CloudDatabaseManagementCredentialdetailsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var test = new CloudDatabaseManagement("test", CloudDatabaseManagementArgs.builder()
.databaseId(oci_database_database.test_database().id())
.managementType(var_.database_cloud_database_management_details_management_type())
.privateEndPointId(var_.database_cloud_database_management_details_private_end_point_id())
.serviceName(var_.database_cloud_database_management_details_service_name())
.credentialdetails(CloudDatabaseManagementCredentialdetailsArgs.builder()
.userName(var_.database_cloud_database_management_details_user_name())
.passwordSecretId(var_.database_cloud_database_management_details_password_secret_id())
.build())
.enableManagement(var_.database_cloud_database_management_details_enable_management())
.port(var_.cloud_database_management_port())
.protocol(var_.cloud_database_management_protocol())
.role(var_.cloud_database_management_role())
.sslSecretId(oci_vault_secret.test_secret().id())
.build());
}
}
import pulumi
import pulumi_oci as oci
test = oci.database.CloudDatabaseManagement("test",
database_id=oci_database_database["test_database"]["id"],
management_type=var["database_cloud_database_management_details_management_type"],
private_end_point_id=var["database_cloud_database_management_details_private_end_point_id"],
service_name=var["database_cloud_database_management_details_service_name"],
credentialdetails=oci.database.CloudDatabaseManagementCredentialdetailsArgs(
user_name=var["database_cloud_database_management_details_user_name"],
password_secret_id=var["database_cloud_database_management_details_password_secret_id"],
),
enable_management=var["database_cloud_database_management_details_enable_management"],
port=var["cloud_database_management_port"],
protocol=var["cloud_database_management_protocol"],
role=var["cloud_database_management_role"],
ssl_secret_id=oci_vault_secret["test_secret"]["id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const test = new oci.database.CloudDatabaseManagement("test", {
databaseId: oci_database_database.test_database.id,
managementType: _var.database_cloud_database_management_details_management_type,
privateEndPointId: _var.database_cloud_database_management_details_private_end_point_id,
serviceName: _var.database_cloud_database_management_details_service_name,
credentialdetails: {
userName: _var.database_cloud_database_management_details_user_name,
passwordSecretId: _var.database_cloud_database_management_details_password_secret_id,
},
enableManagement: _var.database_cloud_database_management_details_enable_management,
port: _var.cloud_database_management_port,
protocol: _var.cloud_database_management_protocol,
role: _var.cloud_database_management_role,
sslSecretId: oci_vault_secret.test_secret.id,
});
resources:
test:
type: oci:Database:CloudDatabaseManagement
properties:
databaseId: ${oci_database_database.test_database.id}
managementType: ${var.database_cloud_database_management_details_management_type}
privateEndPointId: ${var.database_cloud_database_management_details_private_end_point_id}
serviceName: ${var.database_cloud_database_management_details_service_name}
credentialdetails:
userName: ${var.database_cloud_database_management_details_user_name}
passwordSecretId: ${var.database_cloud_database_management_details_password_secret_id}
enableManagement: ${var.database_cloud_database_management_details_enable_management}
port: ${var.cloud_database_management_port}
protocol: ${var.cloud_database_management_protocol}
role: ${var.cloud_database_management_role}
sslSecretId: ${oci_vault_secret.test_secret.id}
Create CloudDatabaseManagement Resource
new CloudDatabaseManagement(name: string, args: CloudDatabaseManagementArgs, opts?: CustomResourceOptions);@overload
def CloudDatabaseManagement(resource_name: str,
opts: Optional[ResourceOptions] = None,
credentialdetails: Optional[_database.CloudDatabaseManagementCredentialdetailsArgs] = None,
database_id: Optional[str] = None,
enable_management: Optional[bool] = None,
management_type: Optional[str] = None,
port: Optional[int] = None,
private_end_point_id: Optional[str] = None,
protocol: Optional[str] = None,
role: Optional[str] = None,
service_name: Optional[str] = None,
ssl_secret_id: Optional[str] = None)
@overload
def CloudDatabaseManagement(resource_name: str,
args: CloudDatabaseManagementArgs,
opts: Optional[ResourceOptions] = None)func NewCloudDatabaseManagement(ctx *Context, name string, args CloudDatabaseManagementArgs, opts ...ResourceOption) (*CloudDatabaseManagement, error)public CloudDatabaseManagement(string name, CloudDatabaseManagementArgs args, CustomResourceOptions? opts = null)
public CloudDatabaseManagement(String name, CloudDatabaseManagementArgs args)
public CloudDatabaseManagement(String name, CloudDatabaseManagementArgs args, CustomResourceOptions options)
type: oci:Database:CloudDatabaseManagement
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args CloudDatabaseManagementArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args CloudDatabaseManagementArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args CloudDatabaseManagementArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args CloudDatabaseManagementArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args CloudDatabaseManagementArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
CloudDatabaseManagement Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
The CloudDatabaseManagement resource accepts the following input properties:
- Credentialdetails
Cloud
Database Management Credentialdetails Args - Database
Id string The database OCID.
- Enable
Management bool (Updatable) Use this flag to enable/disable database management
- Management
Type string (Updatable) Specifies database management type enum:
BASICADVANCED
- Private
End stringPoint Id The OCID of the private endpoint.
- Service
Name string The name of the Oracle Database service that will be used to connect to the database.
- Port int
The port used to connect to the database.
- Protocol string
Protocol used by the database connection.
- Role string
The role of the user that will be connecting to the database.
- Ssl
Secret stringId
- Credentialdetails
Cloud
Database Management Credentialdetails Args - Database
Id string The database OCID.
- Enable
Management bool (Updatable) Use this flag to enable/disable database management
- Management
Type string (Updatable) Specifies database management type enum:
BASICADVANCED
- Private
End stringPoint Id The OCID of the private endpoint.
- Service
Name string The name of the Oracle Database service that will be used to connect to the database.
- Port int
The port used to connect to the database.
- Protocol string
Protocol used by the database connection.
- Role string
The role of the user that will be connecting to the database.
- Ssl
Secret stringId
- credentialdetails
Cloud
Management Credentialdetails Args - database
Id String The database OCID.
- enable
Management Boolean (Updatable) Use this flag to enable/disable database management
- management
Type String (Updatable) Specifies database management type enum:
BASICADVANCED
- private
End StringPoint Id The OCID of the private endpoint.
- service
Name String The name of the Oracle Database service that will be used to connect to the database.
- port Integer
The port used to connect to the database.
- protocol String
Protocol used by the database connection.
- role String
The role of the user that will be connecting to the database.
- ssl
Secret StringId
- credentialdetails
Cloud
Database Management Credentialdetails Args - database
Id string The database OCID.
- enable
Management boolean (Updatable) Use this flag to enable/disable database management
- management
Type string (Updatable) Specifies database management type enum:
BASICADVANCED
- private
End stringPoint Id The OCID of the private endpoint.
- service
Name string The name of the Oracle Database service that will be used to connect to the database.
- port number
The port used to connect to the database.
- protocol string
Protocol used by the database connection.
- role string
The role of the user that will be connecting to the database.
- ssl
Secret stringId
- credentialdetails
Cloud
Database Management Credentialdetails Args - database_
id str The database OCID.
- enable_
management bool (Updatable) Use this flag to enable/disable database management
- management_
type str (Updatable) Specifies database management type enum:
BASICADVANCED
- private_
end_ strpoint_ id The OCID of the private endpoint.
- service_
name str The name of the Oracle Database service that will be used to connect to the database.
- port int
The port used to connect to the database.
- protocol str
Protocol used by the database connection.
- role str
The role of the user that will be connecting to the database.
- ssl_
secret_ strid
- credentialdetails Property Map
- database
Id String The database OCID.
- enable
Management Boolean (Updatable) Use this flag to enable/disable database management
- management
Type String (Updatable) Specifies database management type enum:
BASICADVANCED
- private
End StringPoint Id The OCID of the private endpoint.
- service
Name String The name of the Oracle Database service that will be used to connect to the database.
- port Number
The port used to connect to the database.
- protocol String
Protocol used by the database connection.
- role String
The role of the user that will be connecting to the database.
- ssl
Secret StringId
Outputs
All input properties are implicitly available as output properties. Additionally, the CloudDatabaseManagement resource produces the following output properties:
- Id string
The provider-assigned unique ID for this managed resource.
- Id string
The provider-assigned unique ID for this managed resource.
- id String
The provider-assigned unique ID for this managed resource.
- id string
The provider-assigned unique ID for this managed resource.
- id str
The provider-assigned unique ID for this managed resource.
- id String
The provider-assigned unique ID for this managed resource.
Look up Existing CloudDatabaseManagement Resource
Get an existing CloudDatabaseManagement resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: CloudDatabaseManagementState, opts?: CustomResourceOptions): CloudDatabaseManagement@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
credentialdetails: Optional[_database.CloudDatabaseManagementCredentialdetailsArgs] = None,
database_id: Optional[str] = None,
enable_management: Optional[bool] = None,
management_type: Optional[str] = None,
port: Optional[int] = None,
private_end_point_id: Optional[str] = None,
protocol: Optional[str] = None,
role: Optional[str] = None,
service_name: Optional[str] = None,
ssl_secret_id: Optional[str] = None) -> CloudDatabaseManagementfunc GetCloudDatabaseManagement(ctx *Context, name string, id IDInput, state *CloudDatabaseManagementState, opts ...ResourceOption) (*CloudDatabaseManagement, error)public static CloudDatabaseManagement Get(string name, Input<string> id, CloudDatabaseManagementState? state, CustomResourceOptions? opts = null)public static CloudDatabaseManagement get(String name, Output<String> id, CloudDatabaseManagementState state, CustomResourceOptions options)Resource lookup is not supported in YAML- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Credentialdetails
Cloud
Database Management Credentialdetails Args - Database
Id string The database OCID.
- Enable
Management bool (Updatable) Use this flag to enable/disable database management
- Management
Type string (Updatable) Specifies database management type enum:
BASICADVANCED
- Port int
The port used to connect to the database.
- Private
End stringPoint Id The OCID of the private endpoint.
- Protocol string
Protocol used by the database connection.
- Role string
The role of the user that will be connecting to the database.
- Service
Name string The name of the Oracle Database service that will be used to connect to the database.
- Ssl
Secret stringId
- Credentialdetails
Cloud
Database Management Credentialdetails Args - Database
Id string The database OCID.
- Enable
Management bool (Updatable) Use this flag to enable/disable database management
- Management
Type string (Updatable) Specifies database management type enum:
BASICADVANCED
- Port int
The port used to connect to the database.
- Private
End stringPoint Id The OCID of the private endpoint.
- Protocol string
Protocol used by the database connection.
- Role string
The role of the user that will be connecting to the database.
- Service
Name string The name of the Oracle Database service that will be used to connect to the database.
- Ssl
Secret stringId
- credentialdetails
Cloud
Management Credentialdetails Args - database
Id String The database OCID.
- enable
Management Boolean (Updatable) Use this flag to enable/disable database management
- management
Type String (Updatable) Specifies database management type enum:
BASICADVANCED
- port Integer
The port used to connect to the database.
- private
End StringPoint Id The OCID of the private endpoint.
- protocol String
Protocol used by the database connection.
- role String
The role of the user that will be connecting to the database.
- service
Name String The name of the Oracle Database service that will be used to connect to the database.
- ssl
Secret StringId
- credentialdetails
Cloud
Database Management Credentialdetails Args - database
Id string The database OCID.
- enable
Management boolean (Updatable) Use this flag to enable/disable database management
- management
Type string (Updatable) Specifies database management type enum:
BASICADVANCED
- port number
The port used to connect to the database.
- private
End stringPoint Id The OCID of the private endpoint.
- protocol string
Protocol used by the database connection.
- role string
The role of the user that will be connecting to the database.
- service
Name string The name of the Oracle Database service that will be used to connect to the database.
- ssl
Secret stringId
- credentialdetails
Cloud
Database Management Credentialdetails Args - database_
id str The database OCID.
- enable_
management bool (Updatable) Use this flag to enable/disable database management
- management_
type str (Updatable) Specifies database management type enum:
BASICADVANCED
- port int
The port used to connect to the database.
- private_
end_ strpoint_ id The OCID of the private endpoint.
- protocol str
Protocol used by the database connection.
- role str
The role of the user that will be connecting to the database.
- service_
name str The name of the Oracle Database service that will be used to connect to the database.
- ssl_
secret_ strid
- credentialdetails Property Map
- database
Id String The database OCID.
- enable
Management Boolean (Updatable) Use this flag to enable/disable database management
- management
Type String (Updatable) Specifies database management type enum:
BASICADVANCED
- port Number
The port used to connect to the database.
- private
End StringPoint Id The OCID of the private endpoint.
- protocol String
Protocol used by the database connection.
- role String
The role of the user that will be connecting to the database.
- service
Name String The name of the Oracle Database service that will be used to connect to the database.
- ssl
Secret StringId
Supporting Types
CloudDatabaseManagementCredentialdetails
- Password
Secret stringId Specific database username's password OCID.
- User
Name string Database username
- Password
Secret stringId Specific database username's password OCID.
- User
Name string Database username
- password
Secret StringId Specific database username's password OCID.
- user
Name String Database username
- password
Secret stringId Specific database username's password OCID.
- user
Name string Database username
- password_
secret_ strid Specific database username's password OCID.
- user_
name str Database username
- password
Secret StringId Specific database username's password OCID.
- user
Name String Database username
Import
Import is not supported for this resource.
Package Details
- Repository
- https://github.com/pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
ociTerraform Provider.