# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).
require 'oci'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
data_safe_client = OCI::DataSafe::DataSafeClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
create_sql_collection_response =
data_safe_client.create_sql_collection(
OCI::DataSafe::Models::CreateSqlCollectionDetails.new(
compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
target_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-targetId-Value',
db_user_name: 'EXAMPLE-dbUserName-Value',
display_name: 'EXAMPLE-displayName-Value',
description: 'EXAMPLE-description-Value',
status: 'DISABLED',
sql_level: 'USER_ISSUED_SQL',
freeform_tags: {
'EXAMPLE_KEY_EsILY' => 'EXAMPLE_VALUE_vXZ6CItVGyp8R3vkJSoJ'
},
defined_tags: {
'EXAMPLE_KEY_GWVNF' => { 'EXAMPLE_KEY_crhmq' => 'EXAMPLE--Value' }
}
)
)
# Get the data from response
puts "#{create_sql_collection_response.data}"