The June 2022 release features enhancements to Data Bridge role-based privileges that enable you to grant privileges to roles in custom schemas.
Data Bridge employs role-based privileges to manage access to data. Data Bridge supports two roles: the Consumer role and the Contributor role. For details, see Administer Logins.
You can now grant privileges to those roles in custom schemas:
- All Contributor users are now added to the
- All Consumer users are added to the
For example, to grant control to all contributor-login mapped users to a user defined
CREATE SCHEMA MY_CUSTOM_SCHEMA; GO CREATE TABLE [MY_CUSTOM_SCHEMA].My_TABLE ( C1 int); GO GRANT CONTROL ON SCHEMA::MY_CUSTOM_SCHEMA TORMS_CONTRIBUTOR_PERMISSIONS