× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
chandradipjain(*) reported 2014-05-02T12:16:49Z  · tariqrahiman last modified 2014-05-05T19:26:03Z

For Groups, Grant/Revoke permissions script on Database and schema is not generated.


Priority Low
Complexity Unknown
Component DB - RedShift
Version 15.0
Aqua Data Studio 15.0.0-dev-263
Build #: 37662
Built on: 2014-May-01 05:25:32 PM
OS Environment: Windows 8(x64 bit)
 
Database : Amazon Redshift
 
 
Steps to reproduce:
 
1. Connect to Amazon Redshift server -->  Go to databases folder
2. Exapnd any database 
3. Create Group
   
   CREATE GROUP "va_group"
   GO
   GRANT CREATE ON DATABASE "test" TO GROUP "va_group"
   GO
   GRANT CREATE ON SCHEMA "redshift" TO GROUP "va_group"
   GO
   ALTER GROUP "va_group" ADD USER "user1"
   GO
   GRANT SELECT, INSERT, UPDATE, DELETE ON "redshift"."employee" TO GROUP "va_group"
   GO
   GRANT SELECT ON "redshift"."emp-view" TO GROUP "va_group"
   GO
 
4. Select and right click on above created group --> Select Script Object to window as --> Grant/Revoke option
5. On Query Analyzer window, Grant/Revoke permissions on Table and View script generated.Script for Database and Schema is not generated.
   Is it correct behavior ?.
   
Please see attached screenshot. 
2 attachments

Issue #12023

Closed
Invalid
Resolved 2014-05-05T19:26:03Z
 
 
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