Retrieves detailed information about a specific credential by auth_id.
Returns credential metadata including username (but not password for security),
data product associations, and timestamps. Only the credential owner can access their credentials.