Skip to content

New-AzSqlDatabaseRestorePoint Missing Permission #22715

Open
@jayendranarumugam

Description

@jayendranarumugam

Description

We have a custom role with defined RBAC only for Resotre SQL Server Operation. After we gave all the relevant permission, we still got a specific permission error is missing called Microsoft.Sql/servers/databases/restorePointsOperationResults/read . When I checked the portal, there was no such permission available. There are no docs also there about this role.

Issue script & Debug output

{

  "error": {

    "code": "AuthorizationFailed",

    "message": "The client 'xxxxxx' with object id 'xxxx' does not have authorization to perform action 'Microsoft.Sql/servers/databases/restorePointsOperationResults/read' over scope '/subscriptions/xxxx/resourceGroups/gssqa-db-rg-01/providers/Microsoft.Sql/servers/sql/databases/synapsedbrefresh202307250405/restorePointsOperationResults/133379600050000000' or the scope is invalid. If access was recently granted, please refresh your credentials."

  }

}


### Environment data

```PowerShell
PSVersion                      7.2.4
PSEdition                      Core
GitCommitId                    7.2.4
OS                             Darwin 22.6.0 Darwin Kernel Version 22.6.0: Wed Jul  5 22:21:56 PDT 2023; root:…
Platform                       Unix
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0

Module versions

Az.Accounts Module Version 2.12.5
Az.Sql Module version 4.9.0

Error output

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    SQL - Backup & RestoreService AttentionThis issue is responsible by Azure service team.bugThis issue requires a change to an existing behavior in the product in order to be resolved.customer-reported

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions