This template creates a Secrets Manager secret with a hardcoded password. The secret value is provided an CloudFormation parameter which is stored as a literal string in the secret.

CloudFormation Template