

Download the assignment template from the action button and have it run by the PostgreSQL and/or key vault admin. User cannot assign roles: This message displays when you (the backup admin) don’t have the write access on the PostgreSQL server and/or key vault to assign missing permissions as listed under View details. If one or more access permissions are found missing, it will display one of the error messages – Role assignment not done or User cannot assign roles.Here, the backup service validates if it has all the necessary access permissions to read secret details from the key vault and connect to the database.
#Aws postgresql backup update#
When the secret information update is complete, the validation starts after the key vault information has been updated.
#Aws postgresql backup how to#
Learn more about how to create secrets in the key vault. Ensure that the secret is the PG server connection string in ADO.net format updated with the credentials of the database user that has been granted with the ‘backup’ privileges on the server. The key vault and the secret could pre-exist or be created on the go. With this option, you (backup admin with write access on the key vault) can grant the access permissions on the key vault inline. Select the key vault: Use this option if you know the key vault and secret name. The backup admin along with the Postgres and/or key vault admin need to ensure that the backup vault’s access on the key vault is granted manually outside the configure backup flow for the backup operation to succeed. Therefore, access permissions on the key vault can’t be granted inline. However, with this option, Azure Backup gets no visibility about the key vault you’ve referenced.

You can copy the secret URI from the Key vault -> Secrets (select a secret) -> Secret Identifier. To specify the secret information, use one of the following options:Įnter secret URI: Use this option if the secret URI is shared/known to you. You can also assign the key vault by multi-selecting the rows and click Assign key vault in the top menu of the grid. To assign the key vault at the individual row level, click Select a key vault and secret. You should have already created the relevant secrets in the key vault.
