Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions,
see Getting Started with Amazon Web Services in China
(PDF).
Removing data consumers from a
datashare in Amazon Redshift
You can remove one or more data consumers from a datashare. Data consumers can
be namespaces that uniquely identified Amazon Redshift clusters or Amazon accounts.
- Console
-
To remove one or more data consumers from a datashare on the console,
choose one or more data consumers either from the namespace IDs or Amazon
account. Then, choose Remove.
Amazon Redshift removes the specified data consumers from the datashare. They
lose access to the datashare immediately.
- SQL
-
Use REVOKE USAGE ON to revoke permissions on the datashare to certain
consumers. It revokes USAGE permissions on objects within a datashare and
instantly stops access to all consumer clusters. Listing datashares and
the metadata queries, such as listing databases and tables, doesn't
return the shared objects after access is revoked. Revoke access to the
datashare from namespaces if you don't want to share the data with
the consumers anymore.
REVOKE USAGE ON DATASHARE salesshare FROM NAMESPACE '13b8833d-17c6-4f16-8fe4-1a018f5ed00d';