lowlydba / lowlydba.sqlserver / 2.3.2 / module / credential Configures a credential on a SQL server | "added in version" 1.3.0 of lowlydba.sqlserver" Authors: Joe Krilov (@Joey40), John McCall (@lowlydba)lowlydba.sqlserver.credential (2.3.2) — module
Install with ansible-galaxy collection install lowlydba.sqlserver:==2.3.2
collections: - name: lowlydba.sqlserver version: 2.3.2
Creates, replaces, or removes a credential on a SQL server.
- name: Create a credential with a password lowlydba.sqlserver.credential: sql_instance: sql-01.myco.io identity: ad\\user name: MyCredential password : <Password>
- name: Replace an existing credential lowlydba.sqlserver.credential: sql_instance: sql-01.myco.io identity: MyIdentity force: true
- name: Create a credential using a SAS token for a backup URL lowlydba.sqlserver.credential: sql_instance: sql-01.myco.io identity: SHARED ACCESS SIGNATURE name: https://<azure storage account name>.blob.core.windows.net/<blob container> password : <Shared Access Token>
- name: Remove a credential lowlydba.sqlserver.credential: sql_instance: sql-01.myco.io identity: MyIdentity state: absent
name: description: - The Credential name. required: false type: str force: default: false description: - If this switch is enabled, the existing credential will be dropped and recreated. type: bool state: choices: - present - absent default: present description: - Whether or not the object should be C(present) or C(absent). required: false type: str identity: description: - The Credential Identity. required: true type: str password: description: - Password used to authenticate the Credential Identity. required: false type: str sql_instance: description: - The SQL Server instance to modify. required: true type: str sql_password: description: - Password for SQL Authentication. required: false type: str sql_username: description: - Username for SQL Authentication. required: false type: str provider_name: description: - Specifies the cryptographic provider name for the Enterprise Key Management Provider. required: false type: str mapped_class_type: choices: - CryptographicProvider - None description: - Sets the class associated with the credential. required: false type: str
data: description: Output from the C(New-DbaDbCredential), C(Get-DbaDbCredential), or C(Remove-DbaDbCredential) function. returned: success, but not in check_mode. type: dict