SQL server user provider
The SQL Server user provider allows Devolutions Server to store the SQL account credentials to be used for SQL accounts discovery or to achieve password rotation.
General
Name
Display name of the provider.
Description
Optional description of the provider.
Server
Server name
Hostname of the SQL Server.
Credentials
Credential type
Custom credential or Linked credential options.
Username
Username of the SQL account with rights to list accounts.
Password
Password of the SQL account.
Linked credential
Credential directly linked to a PAM account.
Actions
Add PAM vault
Will create a PAM vault with the provider's name if enabled.
Add a new account discovery configuration
Will open the Account discovery configuration dialog if enabled.
Password settings
Password template used on generation
Password template that will be used to generate the password during the reset password operation.
Least privileges information required for password rotation of an SQL PAM Provider
Minimum Rights For PAM SQL Server
1. Ping() only
Connection database (master if DatabaseName is empty)
Mapped USER; public role is sufficient
CREATE USER [PamServiceLogin] FOR LOGIN [PamServiceLogin];
2. ResetPassword — Instance LOGIN
Server + connection database
See server metadata; ALTER the targeted login; USER in the connection
GRANT VIEW ANY DEFINITION TO [PamServiceLogin];
GRANT ALTER ON LOGIN::[TargetLogin] TO [PamServiceLogin];
GRANT ALTER ANY LOGIN TO [PamServiceLogin];
3. ResetPassword — Contained USER
Target database
Mapped USER; See database metadata; ALTER the targeted user
CREATE USER [PamServiceLogin] FOR LOGIN [PamServiceLogin];
GRANT VIEW DEFINITION TO [PamServiceLogin];
GRANT ALTER ON USER::[TargetUser] TO [PamServiceLogin];
Last updated
Was this helpful?