#12024: Grant options on Group gives error.

chandradipjain(*) reported 2014-05-02T13:24:19Z · last modified 2014-05-05T21:04:41Z

Dev	tariqrahiman
QA	tariqrahiman

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"

4. Grant access on database with grant option.Execute below query

GRANT CREATE ON DATABASE "test" TO GROUP "va_group" WITH GRANT OPTION

It gives error

ERROR: grant options can only be granted to individual users

When i look it into redshift documents, they allows Grant Options on groups also.Please see link

http://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html

5. If this is issue then there is also need to fix in UI also.

All Comments (1) Change History

tariqrahiman 2014-05-05T19:30:09Z

This message is returned from the Redshift Server and not by ADS.