Editing datashares created in your account in Amazon Redshift

On the console, take the following steps to connect to a database first to see the list of datashares created in your account.

Use ALTER DATASHARE to remove objects from datashares at any point from the datashare. To remove a schema, use the following command:

ALTER DATASHARE salesshare REMOVE SCHEMA PUBLIC;

To remove a table, use the following command:

ALTER DATASHARE salesshare REMOVE TABLE public.tickit_sales_redshift;

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';

If you don't want to share the data with the consumers anymore, revoke access to the datashare from AWS accounts:

REVOKE USAGE ON DATASHARE salesshare FROM ACCOUNT '123456789012';