Table to manage access keys for IAM users. Access keys are long-term credentials for an IAM user or the AWS account root user. You can use access keys to sign programmatic requests to the AWS CLI or AWS API (directly or using the AWS SDK).
Access keys consist of two parts: an access key ID (for example, AKIAIOSFODNN7EXAMPLE) and a secret access key (for example, wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY). Like a user name and password, you must use both the access key ID and secret access key together to authenticate your requests.
Access keys can only be listed and deleted. The access keys can be created using the
SELECT * FROM access_key WHERE user_name='user';
DELETE FROM access_key WHERE user_name = 'user';
AWS generated ID for the access key
Status of the Access Key
Reference to the user for this record