Version: 18.0.0-devi-224
Build #: 51053
Build Date: 2016-Sep-05 01:23:07 PM
Operating Environment: Linux (4.4.0-36-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_72-b15
Steps to reproduce:
connect to Azure
Execute following script in Query Analyzer:
CREATE USER [test]
WITHOUT LOGIN
WITH DEFAULT_SCHEMA = [dbo]
GO
CREATE TABLE [db_accessadmin].[Test] (
[c1] varchar(25) NULL,
[c2] varchar(25) NULL
)
GO
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES, CONTROL, ALTER, TAKE OWNERSHIP, VIEW DEFINITION ON [db_accessadmin].[Test] TO [test] WITH GRANT OPTION
GO
Right click on Table Test and click on Alter
Go to Permissions Tab
Revoke the permissions
Switch to Preview SQL Tab
Actual Result:
Following script is generated:
REVOKE SELECT, INSERT, UPDATE, DELETE, REFERENCES, CONTROL, ALTER, TAKE OWNERSHIP, VIEW DEFINITION ON [db_accessadmin].[Test] FROM [test]
GO
Click on Alter
Error message displayed "To revoke or deny grantable privileges, specify
the CASCADE option."
Expected Result:
The following script should be generated:
REVOKE SELECT, INSERT, UPDATE, DELETE, REFERENCES, CONTROL, ALTER, TAKE OWNERSHIP, VIEW DEFINITION ON [db_accessadmin].[Test] FROM [test] CASCADE
GO
Observation:
This is observed for Views,Functions,Procedures objects.
This is also observed in v14,v15,v16 and v17.
