FileMgr

✏️ /usr/lib/python3.9/site-packages/ansible_collections/lowlydba/sqlserver/plugins/modules/user.ps1

✕ Tutup

#!powershell
# -*- 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)

#AnsibleRequires -CSharpUtil Ansible.Basic
#AnsibleRequires -PowerShell ansible_collections.lowlydba.sqlserver.plugins.module_utils._SqlServerUtils
#Requires -Modules @{ ModuleName="dbatools"; ModuleVersion="1.1.112" }

$ErrorActionPreference = "Stop"

$spec = @{
    supports_check_mode = $true
    options = @{
        login = @{type = 'str'; required = $true }
        database = @{type = 'str'; required = $true }
        username = @{type = 'str'; required = $true }
        default_schema = @{type = 'str'; required = $false ; default = 'dbo' }
        external_provider = @{type = 'bool'; required = $false }
        state = @{type = 'str'; required = $false; default = 'present'; choices = @('present', 'absent') }
    }
}

$module = [Ansible.Basic.AnsibleModule]::Create($args, $spec, @(Get-LowlyDbaSqlServerAuthSpec))
$sqlInstance, $sqlCredential = Get-SqlCredential -Module $module
$login = $module.Params.login
$username = $module.Params.username
$database = $module.Params.database
$defaultSchema = $module.Params.default_schema
[nullable[bool]]$externalProvider = $module.Params.external_provider
$state = $module.Params.state
$checkMode = $module.CheckMode

$module.Result.changed = $false

$getUserSplat = @{
    SqlInstance = $sqlInstance
    SqlCredential = $sqlCredential
    User = $username
    Login = $login
    Database = $database
    EnableException = $true
}
$existingUser = Get-DbaDbUser @getUserSplat

if ($state -eq "absent") {
    if ($null -ne $existingUser) {
        try {
            $removeUserSplat = @{
                SqlInstance = $sqlInstance
                SqlCredential = $sqlCredential
                User = $username
                Database = $database
                EnableException = $true
                WhatIf = $checkMode
                Force = $true
                Confirm = $false
            }
            $output = Remove-DbaDbUser @removeUserSplat
            $module.Result.changed = $true
        }
        catch {
            $module.FailJson("Removing user failed: $($_.Exception.Message)", $_)
        }
    }
}
elseif ($state -eq "present") {
    # User exists
    if ($null -ne $existingUser) {
        if ($defaultSchema -ne $existingUser.DefaultSchema) {
            try {
                # No Set-DbaDbUser command exists, use SMO
                $getSchemaSplat = @{
                    SqlInstance = $sqlInstance
                    SqlCredential = $sqlCredential
                    Database = $database
                    Schema = $defaultSchema
                    IncludeSystemDatabases = $true
                    IncludeSystemSchemas = $true
                    EnableException = $true
                }
                $existingSchema = Get-DbaDbSchema @getSchemaSplat

if ($null -ne $existingSchema) {
                    # do schema change
                    if (-not($checkMode)) {
                        $existingUser.DefaultSchema = $defaultSchema
                        $existingUser.Alter()
                        $output = $existingUser
                    }
                    $module.result.changed = $true
                }
                else {
                    $module.FailJson("Schema '$defaultSchema' not found in [$database].")
                }
            }
            catch {
                $module.FailJson("Configuring user failed: $($_.Exception.Message)", $_)
            }
        }
    }
    # New User
    else {
        try {
            $newUserSplat = @{
                SqlInstance = $sqlInstance
                SqlCredential = $sqlCredential
                Username = $username
                Login = $login
                Database = $database
                DefaultSchema = $defaultSchema
                EnableException = $true
                WhatIf = $checkMode
                Force = $true
                Confirm = $false
            }
            if ($externalProvider -eq $true) {
                $newUserSplat.add("ExternalProvider", $true)
            }
            $output = New-DbaDbUser @newUserSplat
            $module.result.changed = $true
        }
        catch {
            $module.FailJson("Creating user failed: $($_.Exception.Message)", $_)
        }
    }
    # If not in check mode, add extra fields we can change to default display set
    if ($null -ne $output) {
        $output.PSStandardMembers.DefaultDisplayPropertySet.ReferencedPropertyNames.Add("DefaultSchema")
    }
}
try {
    if ($null -ne $output) {
        $resultData = ConvertTo-SerializableObject -InputObject $output
        $module.Result.data = $resultData
    }
    $module.ExitJson()
}
catch {
    $module.FailJson("Failure: $($_.Exception.Message)", $_)
}

Batal

⬅ plugins 61 item

Nama	Tipe	Ukuran	Diubah	Perm	Aksi
📁 __pycache__	dir	—	16/09/24 06:47	0755	📂
📄 ag_listener.ps1	ps1	3.1 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 ag_listener.py	py	2.2 KB	08/11/23 12:12	0644	✏️ ⬇
📄 ag_replica.ps1	ps1	7.9 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 ag_replica.py	py	4.7 KB	08/11/23 12:12	0644	✏️ ⬇
📄 agent_job.ps1	ps1	4.6 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 agent_job.py	py	2.4 KB	08/11/23 12:12	0644	✏️ ⬇
📄 agent_job_category.ps1	ps1	2.2 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 agent_job_category.py	py	1.3 KB	08/11/23 12:12	0644	✏️ ⬇
📄 agent_job_schedule.ps1	ps1	6.4 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 agent_job_schedule.py	py	4.8 KB	08/11/23 12:12	0644	✏️ ⬇
📄 agent_job_step.ps1	ps1	6.3 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 agent_job_step.py	py	3.3 KB	08/11/23 12:12	0644	✏️ ⬇
📄 availability_group.ps1	ps1	9.6 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 availability_group.py	py	4.9 KB	08/11/23 12:12	0644	✏️ ⬇
📄 backup.ps1	ps1	5.7 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 backup.py	py	5.8 KB	08/11/23 12:12	0644	✏️ ⬇
📄 credential.ps1	ps1	4.3 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 credential.py	py	2.4 KB	08/11/23 12:12	0644	✏️ ⬇
📄 database.ps1	ps1	9.2 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 database.py	py	2.6 KB	08/11/23 12:12	0644	✏️ ⬇
📄 dba_multitool.ps1	ps1	2.1 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 dba_multitool.py	py	2 KB	08/11/23 12:12	0644	✏️ ⬇
📄 first_responder_kit.ps1	ps1	2.8 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 first_responder_kit.py	py	2.7 KB	08/11/23 12:12	0644	✏️ ⬇
📄 hadr.ps1	ps1	2.4 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 hadr.py	py	1.7 KB	08/11/23 12:12	0644	✏️ ⬇
📄 install_script.ps1	ps1	3.2 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 install_script.py	py	3.3 KB	08/11/23 12:12	0644	✏️ ⬇
📄 instance_info.ps1	ps1	1.8 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 instance_info.py	py	931 B	08/11/23 12:12	0644	✏️ ⬇
📄 login.ps1	ps1	5.4 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 login.py	py	2.4 KB	08/11/23 12:12	0644	✏️ ⬇
📄 maintenance_solution.ps1	ps1	3.9 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 maintenance_solution.py	py	3.2 KB	08/11/23 12:12	0644	✏️ ⬇
📄 memory.ps1	ps1	1.5 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 memory.py	py	1.2 KB	08/11/23 12:12	0644	✏️ ⬇
📄 nonquery.ps1	ps1	1.5 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 nonquery.py	py	1.3 KB	08/11/23 12:12	0644	✏️ ⬇
📄 resource_governor.ps1	ps1	2.2 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 resource_governor.py	py	1.3 KB	08/11/23 12:12	0644	✏️ ⬇
📄 restore.ps1	ps1	7.6 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 restore.py	py	7.3 KB	08/11/23 12:12	0644	✏️ ⬇
📄 rg_resource_pool.ps1	ps1	4.2 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 rg_resource_pool.py	py	2.6 KB	08/11/23 12:12	0644	✏️ ⬇
📄 rg_workload_group.ps1	ps1	4.4 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 rg_workload_group.py	py	3 KB	08/11/23 12:12	0644	✏️ ⬇
📄 sa.ps1	ps1	3.5 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 sa.py	py	2 KB	08/11/23 12:12	0644	✏️ ⬇
📄 sp_configure.ps1	ps1	1.8 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 sp_configure.py	py	1.4 KB	08/11/23 12:12	0644	✏️ ⬇
📄 sp_whoisactive.ps1	ps1	1.6 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 sp_whoisactive.py	py	1.7 KB	08/11/23 12:12	0644	✏️ ⬇
📄 spn.ps1	ps1	2.7 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 spn.py	py	1.9 KB	08/11/23 12:12	0644	✏️ ⬇
📄 tcp_port.ps1	ps1	2.3 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 tcp_port.py	py	1.7 KB	08/11/23 12:12	0644	✏️ ⬇
📄 traceflag.ps1	ps1	2.1 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 traceflag.py	py	1.5 KB	08/11/23 12:12	0644	✏️ ⬇
📄 user.ps1	ps1	4.8 KB	08/11/23 12:12	0644	✏️ ⬇
🐍 user.py	py	2 KB	08/11/23 12:12	0644	✏️ ⬇

✏️ Rename

🔑 Ubah Permission