Pre-conditions - Ensure ADS is launched and opened with few DB server connected
1) Select any DB (Tried with Maria DB, DB2 LUW) drill down to Table level
2) Right click on any Table--->Script to Object to Window As/New Window As--->Click on Grant/Revoke
Actual
SQL Scripts for Grant/Revoke are not getting generated.
Additional note - For all other option like Select/Insert/Update/delete/Create etc.. SQL scripts are getting generated
133 KB
119 KB
Issue #15684 |
Closed |
Invalid |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
The user must have permissions on the object first to generate a grant or revoke statement. ADS will only generate script for the permissions that it has on that object. See here. No permissions, no script. This is working as designed.