QuestionQ65

VerifiedData Security and Governance

A 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?

Explanation

Amazon Redshift schemas separate related tables and views within the same database and support schema-based access control. Granting each department access to its own schema provides the required isolation while still allowing authorized users to reference objects in both schemas in one SQL query. This avoids the additional management associated with separate databases; object names alone do not enforce permissions, and Redshift database-object privileges are granted with Redshift SQL rather than IAM identity policies.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!