Amazon 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.
Source:: Amazon AWS