1 files changed, 81 insertions, 0 deletions
diff --git a/ansible_collections/lowlydba/sqlserver/plugins/modules/user.py b/ansible_collections/lowlydba/sqlserver/plugins/modules/user.py
new file mode 100644
index 000000000..b9c36d069
--- /dev/null
+++ b/ansible_collections/lowlydba/sqlserver/plugins/modules/user.py
@@ -0,0 +1,81 @@
+#!/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: user
+short_description: Configures a user within a database
+description:
+  - Creates, modifies, or removes a user in a database.
+version_added: 1.1.0
+options:
+  login:
+    description:
+      - Name of the login that the user is mapped to.
+    type: str
+    required: true
+  database:
+    description:
+      - Database for the user.
+    type: str
+    required: true
+  username:
+    description:
+      - Name of the user.
+    type: str
+    required: true
+  external_provider:
+    description:
+      - Specifies that the user is for Azure AD Authentication. Only used when creating a new user, this cannot be modified for an existing user.
+    type: bool
+    required: false
+  default_schema:
+    description:
+      - The default database schema for the user.
+    type: str
+    required: false
+    default: "dbo"
+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
+  - lowlydba.sqlserver.state
+'''
+
+EXAMPLES = r'''
+- name: Create a user
+  lowlydba.sqlserver.user:
+    sql_instance: sql-01.myco.io
+    login: TheIntern
+    username: TheIntern
+    database: InternProject1
+
+- name: Change user's schema
+  lowlydba.sqlserver.login:
+    sql_instance: sql-01.myco.io
+    login: TheIntern
+    username: TheIntern
+    database: InternProject1
+    default_schema: dev
+
+- name: Remove a user
+  lowlydba.sqlserver.login:
+    sql_instance: sql-01.myco.io
+    login: TheIntern
+    username: TheIntern
+    database: InternProject1
+    state: absent
+'''
+
+RETURN = r'''
+data:
+  description: Output from the C(New-DbaDbUser), C(Get-DbaDbUser), or C(Remove-DbaDbUser) function.
+  returned: success, but not in check_mode.
+  type: dict
+'''