Server IP : 85.214.239.14 / Your IP : 3.145.163.26 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /lib/python3/dist-packages/ansible_collections/lowlydba/sqlserver/plugins/modules/ |
Upload File : |
#!/usr/bin/python # -*- coding: utf-8 -*- # (c) 2022, John McCall (@lowlydba) # GNU General Public License v3.0+ (see COPYING or https://www.gnu.org/licenses/gpl-3.0.txt) DOCUMENTATION = r''' --- module: sa short_description: Configure the C(sa) login for security best practices description: - Rename, disable, and reset the password for the C(sa) login on a SQL Server instance per best practices. options: password: description: - Password for the login. type: str required: false new_name: description: - The new name to rename the C(sa) login to. type: str required: false enabled: description: - Whether the login is enabled or disabled. type: bool required: false default: true version_added: '0.4.0' password_must_change: description: - Enforces user must change password at next login. - When specified, will enforce I(password_expiration_enabled) and I(password_policy_enforced) as they are required. type: bool required: false password_policy_enforced: description: - Enforces password complexity policy. type: bool required: false password_expiration_enabled: description: - Enforces password expiration policy. Requires I(password_policy_enforced=true). type: bool required: false version_added: 0.3.0 author: "John McCall (@lowlydba)" requirements: - L(dbatools,https://www.powershellgallery.com/packages/dbatools/) PowerShell module extends_documentation_fragment: - lowlydba.sqlserver.sql_credentials - lowlydba.sqlserver.attributes.check_mode - lowlydba.sqlserver.attributes.platform_all ''' EXAMPLES = r''' - name: Disable sa login lowlydba.sqlserver.sa: sql_instance: sql-01.myco.io disable: true - name: Rename sa login lowlydba.sqlserver.sa: sql_instance: sql-01.myco.io new_name: 'notthesayourelookingfor' ''' RETURN = r''' data: description: Output from the C(Set-DbaLogin) function. returned: success, but not in check_mode. type: dict '''