Amazon Redshift announces support for scoped permissions and object-level privileges in data sharing
Share
Services
[Amazon Redshift](https://aws.amazon.com/redshift/) customers can now use scoped permissions to manage permissions for a role or user on a database or schema scope, avoiding the need to manually grant permissions on every object. Scoped permissions apply to objects in the selected scope when you grant or revoke the permission, as well as to new objects created after you grant or revoke the permission. For example, granting SELECT permission to tables in a schema allows access to current and future tables within the schema. Scoped permissions can also be used on shared databases created from a datashare.
In addition to scoped permissions, Amazon Redshift is introducing a new capability to allow data consumers to manage object-level permissions on shared data. Amazon Redshift already supports sharing data at the granularity of objects from data sharing producer. With object-level permissions on data sharing consumers, you can grant access in shared databases at a granular level from data sharing consumers than the previously possible permissions at schema level only. Users and roles on data sharing consumers will only have the access to the objects they have permission for. As a data consumer, in order to define object-level privilege on the shared database or schema, you need to create databases from data sharing with the WITH PERMISSIONS option.
Scoped permission and datashare object-level premissions are now available in all AWS commercial and the AWS GovCloud (US) Regions where [Amazon Redshift is available](https://aws.amazon.com/about-aws/global-infrastructure/regional-product-services/). You can learn more about this feature from the Redshift [management guide](https://docs.aws.amazon.com/redshift/latest/dg/t%5Fscoped-permissions.html).
What else is happening at Amazon Web Services?
Amazon AppStream 2.0 users can now save their user preferences between streaming sessions
December 13th, 2024
Services
Share
AWS Elemental MediaConnect Gateway now supports source-specific multicast
December 13th, 2024
Services
Share
Amazon EC2 instances support bandwidth configurations for VPC and EBS
December 13th, 2024
Services
Share
AWS announces new AWS Direct Connect location in Osaka, Japan
December 13th, 2024
Services
Share
Amazon DynamoDB announces support for FIPS 140-3 interface VPC and Streams endpoints
December 13th, 2024
Services
Share