I am developing a background worker that moves database between pools, create a pool, delete a pool, etc. I couldn't find in Microsoft document what the minimum required access to do such tasks? Admin to Azure SQL Server, Contributor or anything? I also read both server and database statistics from sys.* databases.
What is the minimum required access level (permission) required to move, create, remove Azure SQL elastic pool?
329 Views Asked by Dan Hunex At
1
There are 1 best solutions below
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in AZURE
- How to update to the latest external Git in Azure Web App?
- I need an azure product that executes my intensive ffmpeg command then dies, and i only get charged for the delta. Any Tips?
- Inject AsyncCollector into a service
- mutual tls authentication between app service and function app
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- Application settings for production deployment slot in Azure App Services
- Encountered an error (ServiceUnavailable) from host runtime on Azure Function App
- Implementing Incremental consent when using both application and delegated permissions
- Invalid format for email address in WordPress on Azure app service
- Producer Batching Service Bus Vs Kafka
- Integrating Angular External IP with ClusterIP of .NET microservices on AKS
- Difficulty creating a data pipeline with Fabric Datafactory using REST
- Azure Batch for Excel VBA
- How to authenticate only Local and Guest users in Azure AD B2C and add custom claims in token?
- Azure Scale Sets and Parallel Jobs
Related Questions in AZURE-SQL-SERVER
- Terraform - Add tags to failover SQL databases
- ASP.NET Core (Azure app service) application reruns Main() method if it's taking a long time
- Using order by clause with skip and take fails
- Error SQL71501: View: [PLTG].[MVW_SAURAV] has an unresolved reference to Column [Process_Key]
- Delete data from all tables except master tables with foreign key contraints in SQL Azure
- List all databases by elastic pool using T-Sql in Azure Sql
- Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The wait operation timed out
- Connect Azure App Service and Azure SQL VM
- Create Bearer Token with Permissions for Azure Data Sync Api Trigger
- Azure SQL Server Pipeline Restore/Copy Process
- Connection was denied since Deny Public Network Access is set to Yes
- Determine if a database is an azure database
- Why is Azure Data Studio Profiler not capturing stored procedures with large input data?
- Query tables from different servers in Azure SQL
- where to check the resource usage for azure SQL server
Related Questions in AZURE-SQL
- Azure web app connection to azure sql fails?
- Azure SQL Server BCP -
- Azure Flask app | Azure SQL - pyodbc.OperationalError Timeout with load_dotenv()
- How to monitor if table is empty in Azure SQL?
- Add Azure Blob Partitions to Azure SQL Table
- How to store hot and cold data with Azure SQL
- adf function to read only certain portion of filename based on pattern
- Identifying distinct sets of rows in SQL
- Best way to export firebase into azure sql
- offline DMS migration from Azure SQL VM to Azure SQL DB
- What is the minimum required access level (permission) required to move, create, remove Azure SQL elastic pool?
- 'java.lang.RuntimeException: Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl,'
- Where does the DataIO in Azure Query Performance Insights come from, when single queries are fast
- Azure SQL Contained User. Back-end can't connect using connection string
- sql managed instance authentication fails when using AAD integrated method
Related Questions in AZURE-ELASTICPOOL
- Optimizing Azure SQL Elastic Pools with high memory but low CPU
- Moving data from Azure SQL to shards using elastic query
- Elastic pool storage utilization percent not decreasing
- How to move Azure Elastic Pool between different SQL Servers
- unexpected costs when using Elastic Pools
- How to set the maintenance window for elastic pool in Bicep script?
- Azure terraform add database to elastic pool
- Azure Data Factory - Scale elasticpool with web activity
- I need to clone an Azure SQL Database, which will take it past the SQL Pool Max Data Size - will it automatically increase?
- Delete database shard mapping and shard databases in SQL Server to clean up tenant resources
- Azure Single Database vs Elastic Pool Databases
- How do I create a database in an elastic pool using bicep?
- Azure Elastic Pool eDTU and Storage per DB / Pool?
- Is it possible to change Azure Elastic Pool server version
- List all databases by elastic pool using T-Sql in Azure Sql
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You need atleat Contributor role to perform create, delete, move, etc. related task.
A Contributor role allow to Grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC, manage assignments in Azure Blueprints, or share image galleries.
Please refer https://learn.microsoft.com/en-us/azure/role-based-access-control/built-in-roles#contributor for more details.
To read data from system tables make sure you have required role assigned on database level, e.g., db_datareader role.