SqlLogin: Resource refactoring proposal

[johlju]

Resource proposal

A class-based SqlLogin resource would ensure SQL Server logins exist, are enabled or disabled, and have correct properties. Commands would include Get-SqlDscLogin, New-SqlDscLogin, Remove-SqlDscLogin, Enable-SqlDscLogin, Disable-SqlDscLogin, and Test-SqlDscIsLoginEnabled.

Proposed properties

Property	Type qualifier	Data type	Description	Default value	Allowed values
Ensure	Key	String	Whether the login should be Present or Absent	Present	Present, Absent
Name	Key	String	Login name	None	Any valid login name
LoginType	Write	String	Type of login (SQL, Windows, etc.)	None	SQLLogin, WindowsUser, etc.
DefaultDatabase	Write	String	Default database for login	None	Any valid database name
Enabled	Write	Boolean	Whether the login is enabled	True	True, False
Password	Write	SecureString	Password for SQL logins	None	Valid password

Special considerations or limitations

Must support both SQL and Windows logins, handle enable/disable scenarios, and ensure idempotency. Contributors should ensure sensitive data is handled securely and account for permissions required to manage logins.