Data Source: oci_database_management_managed_database_user_object_privileges
This data source provides the list of Managed Database User Object Privileges in Oracle Cloud Infrastructure Database Management service.
Gets the list of object privileges granted to a specific user.
Example Usage
data "oci_database_management_managed_database_user_object_privileges" "test_managed_database_user_object_privileges" {
#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_object_privilege_name
opc_named_credential_id = var.managed_database_user_object_privilege_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:
object_privilege_collection
- The list of object_privilege_collection.
ManagedDatabaseUserObjectPrivilege Reference
The following attributes are exported:
items
- An array of object privileges.common
- Indicates how the object privilege 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)grant_option
- Indicates whether the privilege is granted with the GRANT OPTION (YES) or not (NO).grantor
- The name of the user who granted the object privilege.hierarchy
- Indicates whether the privilege is granted with the HIERARCHY OPTION (YES) or not (NO).inherited
- Indicates whether the granted privilege is inherited from another container (YES) or not (NO).name
- The name of the privilege on the object.object
- The name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.owner
- The owner of the object.schema_type
- The type of object.