× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nileshhmali reported 2013-07-18T13:01:32Z  · nhilam last modified 2018-03-10T02:16:07Z

Change Object Type to "GROUPS" in the header, when Include Descriptive Header is selected


Dev
QA
Priority Major
Complexity Complex
Component Tools - Server Script Gen
Version Future - PM
ADS version : ADS-windows-x64-14.0-Beta-68
Database version: SybaseIQ-16.0
Driver: iAnywhere.
 
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-beta-68 on Jul-18-2013 06:23:02 PM
    Objects: ROLE
 */
 
  REVOKE MEMBERSHIP IN GROUP "dbo" FROM "PUBLIC"
   GO
  REVOKE RESOURCE FROM "dbo"
   GO
  REVOKE DBA FROM "dbo"
  GO
  REVOKE CONNECT FROM "dbo"
  GO
 
 GRANT CONNECT TO "dbo" IDENTIFIED BY '<password>'
 GO
 GRANT GROUP TO "dbo"
 GO
 GRANT DBA TO "dbo"
 GO
 GRANT RESOURCE TO "dbo"
 GO
 GRANT MEMBERSHIP IN GROUP "dbo" TO "PUBLIC"
 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.


 

1 attachment

Issue #9618

In Progress
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017