Data Bridge, June 2022

The June 2022 release features enhancements to Data Bridge role-based privileges that enable you to grant privileges to roles in custom schemas.

Custom Schema Permissions

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 RMS_CONTRIBUTOR_PERMISSIONS database role.
  • All Consumer users are added to the RMS_CONSUMER_PERMISSIONS database role.

For example, to grant control to all contributor-login mapped users to a user defined SCHEMA, MY_CUSTOM_SCHEMA:


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