ADS version : ADS-windows-x64-14.0-rc-44
Database version:Postgres-9.2
Change Object Type to "GROUPS" in the header instead of "ROLES", when Include Descriptive Header is selected
Go to security tree nodes->right click groups->Select tools->select Server script generator->opened Server script generator window->check groups in object type->check objects and click on next button.
Generated txt file is as below
/*
Script generated by Aqua Data Studio 14.0.0-rc-44 on Oct-10-2013 01:48:31 PM
Objects: ROLE
*/
REVOKE CREATE, TEMP ON DATABASE "Nishtha" FROM GROUP "nishtha1"
GO
DROP GROUP "nishtha1"
GO
DROP GROUP "dbo"
GO
CREATE GROUP "dbo" WITH SYSID 16507
GO
ALTER GROUP "dbo" ADD USER "postgres"
GO
ALTER GROUP "dbo" ADD USER "test2"
GO
ALTER GROUP "dbo" ADD USER "tester"
GO
ALTER GROUP "dbo" ADD USER "test1"
GO
CREATE GROUP "nishtha1" WITH SYSID 24899
GO
GRANT CREATE, TEMP ON DATABASE "Nishtha" TO GROUP "nishtha1"
GO
ALTER GROUP "nishtha1" ADD USER "postgres"
GO
ALTER GROUP "nishtha1" ADD USER "test1"
GO
You will observed that Object Type is "Role" where when we generated script we have specified Object type as "Groups". File should have the same.
