DanielSmon

-- For more useful info on permissions, see:
--     https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-role-members-transact-sql?view=sqlallproducts-allversions

-- Create logins and users on Azure SQL databases.
-- Adjust roles and schemas appropriately
DECLARE @user   varchar(255) = 'USERNAME';
DECLARE @pass   varchar(255) = 'PASSWORD';
DECLARE @schema varchar(255) = '[dbo]';

IF ((SELECT DB_NAME()) = 'master')

DanielSmon

$session = New-Object Microsoft.PowerShell.Commands.WebRequestSession

$uri = "https://www.domain.com/action"

# Cookies from browser
# Paste in cookie values from browser request
$allCookies = "cookie1=cookievalue1; cookie2=cookievalue2"

foreach ($cookiePair in $allCookies.Split((";"))) {
  $cookieValues = $cookiePair.Trim().Split("=")

DanielSmon

Function Test-Administrator
{
    $user = [Security.Principal.WindowsIdentity]::GetCurrent();
    (New-Object Security.Principal.WindowsPrincipal $user).IsInRole([Security.Principal.WindowsBuiltinRole]::Administrator)
}

DanielSmon

Function Decrypt-SecureString {
param(
    [Parameter(ValueFromPipeline=$true,Mandatory=$true,Position=0)]
    [System.Security.SecureString]
    $sstr
)
  $marshal = [System.Runtime.InteropServices.Marshal]
  $ptr = $marshal::SecureStringToBSTR( $sstr )
  $str = $marshal::PtrToStringBSTR( $ptr )
  $marshal::ZeroFreeBSTR( $ptr )