Comments (1)
I seem to have solved this by modifying the maintenance procedure, running it with execute as SELF (which gives the permissions of the person who ran the create/alter script). This means the procedure can run with the required server-level permissions, which cannot be granted to users at database level.
CREATE PROCEDURE [dbo].[AzureSQLMaintenance]
(
@operation nvarchar(10) = null,
@mode nvarchar(10) = 'smart',
@ResumableIndexRebuild bit = 0,
@RebuildHeaps bit = 0,
@LogToTable bit = 0,
@debug nvarchar(10) = 'none'
)
WITH EXECUTE AS SELF
AS ...
from azuresql.
Related Issues (20)
- Out of date stats aren't always updated HOT 1
- Heaps and Forwarded Records HOT 1
- Statistics maintenance go through all statistics regardless mode option HOT 2
- Indexes maintenance process indexes with 0 pages as well HOT 1
- Add WhatIf Functionality HOT 1
- Handle table-valued functions HOT 2
- Minor help text issue HOT 1
- AzureSQLMaintenance.txt horizontal partitioning support
- AzureSQLMaintenance.txt - When using All and smart option no need to skip stats update for indexes that go for reorganize HOT 1
- Add time limit for maintenance (time limit for start of new command)
- Can I safely remove the `with nowait` from the AzureSQLMaintenance script? HOT 1
- Operation cannot be performed resumably on a table with a Clustered Columnstore Index
- Add a @Version output parameter so we can auto-check for out-of-date procedures
- Add support for "per table" settings for stats update HOT 2
- AzureSQLMaintenance tries to rebuild indexes online in table with FILESTREAM columns
- DTU Exhaustion HOT 1
- Should FULLSCAN be the default? Consider making it optional
- The object selection needs to filter external tables HOT 2
- Get index information per tables instead of once for all tables
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from azuresql.