salt.states.mssql_user¶

Management of Microsoft SQLServer Users¶

The mssql_user module is used to create and manage SQL Server Users

frank:
  mssql_user.present:
    - database: yolo

salt.states.mssql_user.absent(name, **kwargs)¶

Ensure that the named user is absent

salt.states.mssql_user.present(name, login=None, domain=None, database=None, roles=None, options=None, **kwargs)¶

Checks existence of the named user. If not present, creates the user with the specified roles and options.

name: The name of the user to manage
login: If not specified, will be created WITHOUT LOGIN
domain: Creates a Windows authentication user. Needs to be NetBIOS domain or hostname
database: The database of the user (not the login)
roles: Add this user to all the roles in the list
options: Can be a list of strings, a dictionary, or a list of dictionaries