Aqua Data Studio 15.0.0-dev-86
Database- Teradata Aster 5.0
1.In ADS,connect to Teradata Aster Database,expand it
Go to Databases node,expand it
Go to desired database,expand it
Go to Roles tree node,expand it
Select any role,right click and select Alter Role option
Alter Role window get opened
In Alter Role window go to Role Tab
In Role Tab,check roles which is display in list
Go to Preview SQL Tab
In Preview SQL Tab,Grant script get generated but "GO" statement
separator is missing after last Grant script
2.Go to Databases node,expand it
Go to desired database,expand it
Go to Public schema,expand it
Go to Tables tree node,expand it
Select any Table,right click and select Alter Table option
Alter Table window get opened go to Permissions Tab
In Permissions Tab,select Permissions for Grantee Type:Users or Roles
check users or roles which is display in list
Go to Preview SQL Tab
In Preview SQL Tab,Grant script get generated and "GO" statement
separator is display after last Grant script