salt.states.mssql_login¶
Management of Microsoft SQLServer Logins¶
The mssql_login module is used to create and manage SQL Server Logins
frank:
mssql_login.present
- domain: mydomain
- salt.states.mssql_login.absent(name, **kwargs)¶
Ensure that the named login is absent
- name
The name of the login to remove
- salt.states.mssql_login.present(name, password=None, domain=None, server_roles=None, options=None, **kwargs)¶
Checks existence of the named login. If not present, creates the login with the specified roles and options.
- name
The name of the login to manage
- password
Creates a SQL Server authentication login Since hashed passwords are varbinary values, if the new_login_password is 'long', it will be considered to be HASHED.
- domain
Creates a Windows authentication login. Needs to be NetBIOS domain or hostname
- server_roles
Add this login to all the server roles in the list
- options
Can be a list of strings, a dictionary, or a list of dictionaries
