Amazon Redshift now supports metadata security that enables administrators to restrict the visibility on their catalog data based on user roles and permissions. Users can now see only the metadata for databases, schema, and tables/views that they have access to. It enables customers to deploy multi-tenant applications on a provisioned cluster or Serverless namespace.
Source:: Amazon AWS