Data Bridge, June 2022
7 months ago by Todd Smith
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