Return
-
Title
The Edit Permissions list is missing some server level securables -
Description
There are 31 server level securables, according to SQL Server documentation. However, the Edit Permissions dialog only lists 25 of them.
The missing permissions are:
ALTER ANY AVAILABILITY GROUP
ALTER ANY EVENT SESSION
ALTER ANY SERVER AUDIT
ALTER ANY SERVER ROLE
CREATE AVAILABILITY GROUP
CREATE SERVER ROLE -
Resolution
WORKAROUND:
Grant the missing permissions manually using TSQL.
STATUS:
This issue is fixed in Toad for SQL Server 6.7. This version can be downloaded from the downloads section of our website, which you can access by clicking here. -
Defect ID
TSS-1083