turbot/oci

steampipe plugin install ocisteampipe plugin install oci
On This Page
Get Involved

Table: oci_identity_customer_secret_key

A customer secret key is an Oracle-provided key for using the Object Storage Service's Amazon S3 compatible API. The key consists of a secret key/access key pair. A user can have up to two secret keys at a time.

Examples

Basic info

select
id,
display_name,
user_id,
user_name,
time_created
from
oci_identity_customer_secret_key;

List inactive customer secret keys

select
id,
display_name,
user_id,
user_name,
lifecycle_state,
time_created
from
oci_identity_customer_secret_key
where
lifecycle_state = 'INACTIVE';

Count customer secret keys by user

select
user_id,
count (id) as customer_secret_key_count
from
oci_identity_customer_secret_key
group by
user_id;

.inspect oci_identity_customer_secret_key

OCI Identity Customer Secret Key

NameTypeDescription
display_nametextThe displayName you assign to the secret key.
idtextThe OCID of the secret key.
inactive_statusbigintThe detailed status of INACTIVE lifecycleState.
lifecycle_statetextThe secret key's current state.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneDate and time the CustomerSecretKey object was created.
time_expirestimestamp without time zoneDate and time when this password will expire.
titletextTitle of the resource.
user_idtextThe OCID of the user the password belongs to.
user_nametextThe name of the user the password belongs to.