Data Source: oci_database_management_managed_database_user_roles

This data source provides the list of Managed Database User Roles in Oracle Cloud Infrastructure Database Management service.

Gets the list of roles granted to a specific user.

Example Usage

data "oci_database_management_managed_database_user_roles" "test_managed_database_user_roles" {
	#Required
	managed_database_id = oci_database_management_managed_database.test_managed_database.id
	user_name = oci_identity_user.test_user.name

	#Optional
	name = var.managed_database_user_role_name
	opc_named_credential_id = var.managed_database_user_role_opc_named_credential_id
}

Argument Reference

The following arguments are supported:

• managed_database_id - (Required) The OCID of the Managed Database.
• name - (Optional) A filter to return only resources that match the entire name.
• opc_named_credential_id - (Optional) The OCID of the Named Credential.
• user_name - (Required) The name of the user whose details are to be viewed.

Attributes Reference

The following attributes are exported:

• role_collection - The list of role_collection.

ManagedDatabaseUserRole Reference

The following attributes are exported:

• items - An array of roles.
  • admin_option - Indicates whether the role is granted with the ADMIN OPTION (YES) or not (NO).
  • common - Indicates how the role was granted. Possible values: YES if the role is granted commonly (CONTAINER=ALL is used) NO if the role is granted locally (CONTAINER=ALL is not used)
  • default_role - Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO).
  • delegate_option - Indicates whether the role is granted with the DELEGATE OPTION (YES) or not (NO).
  • inherited - Indicates whether the granted role is inherited from another container (YES) or not (NO).
  • name - The name of the role granted to the user.