QuestionQ65
VerifiedData Security and GovernanceA company uses an Amazon Redshift cluster as a data warehouse shared by two departments. To meet a security policy, each department must have distinct access permissions.
Department A must be able to access Department A tables and views. Department B must be able to access Department B tables and views.
The company frequently runs SQL queries that use objects from both departments in a single query.
Which solution meets these requirements with the LEAST operational overhead?
Community Discussion