Data Source: oci_database_management_managed_databases_user_system_privilege

This data source provides details about a specific Managed Databases User System Privilege resource in Oracle Cloud Infrastructure Database Management service.

Gets the list of system privileges granted to a specific user.

Example Usage

data "oci_database_management_managed_databases_user_system_privilege" "test_managed_databases_user_system_privilege" {
	#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_databases_user_system_privilege_name
}

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.
• user_name - (Required) The name of the user whose details are to be viewed.

Attributes Reference

The following attributes are exported:

• items - An array of system privileges.
  • admin_option - Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
  • common - Indicates how the system privilege was granted. Possible values: YES if the system privilege is granted commonly (CONTAINER=ALL is used) NO if the system privilege is granted locally (CONTAINER=ALL is not used)
  • inherited - Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
  • name - The name of a system privilege.