Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Preferences
Contact Us
Feedback
AWS Documentation
Create an AWS Account
Granting access to view datashares - Amazon Redshift

Granting access to view datashares

PDFRSS

A superuser can provide access to users who aren't superusers so that they can view the datashares created by all users.

To grant access to a datashare for a user, use the following command to provide datashare access for a user, where datashare_name is the name of the datashare and user-name is the name of the user for whom you want to provide access.

grant share on datashare datashare_name to "IAM:test_user";

To grant access to a datashare for a user group, first create a user group with users. For information on how to create user groups, see CREATE GROUP. Then, grant datashare access to a user using the following command, where datashare_name is the name of the datashare and user-group is the name of the user-group to that you want to grant access.

grant share on datashare datashare_name to group user_group;

For information on how to use the GRANT statement, see GRANT.

Previous topic:

Data sharing

Need help?

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.