This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Hello.
I'm can't drop system versioned tables in master db in Azure SQL
but request
ALTER TABLE dbo.Employees
SET (SYSTEM_VERSIONING = OFF);
returns an error: Msg 13538, Level 16, State 3, Line 1
You do not have the required permissions to complete the operation.
How I can delete this tables?
ALTER TABLE dbo.Eployees
Typo? Eployees vs Employees
Yes. ALTER TABLE dbo.Employees
You need to find some who has sufficient permission. For this operation you need at ALTER permission on the table.
You need to find some who has sufficient permission. For this operation you need at ALTER permission on the table.
I try from administrator user, which was created when the instance was deployed.
Also I try from EntraID Administrator and this doesn't work either
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
With any of these users that you think are admin, what does this query return:
SELECT * FROM sys.fn_my_permissions(NULL, 'DATABASE')
For an admin it should return a little more than 100 rows, and on of the rows should read CONTROL.