Multi-Tenant Support

EDIS Online User Guide – Multi-Tenant Support

When a service ID is created in EDIS to access a database, FTP server, SharePoint Connection or other connection, the connection is accessible to anyone in the EDIS_Role by default. To lock a service ID to a specific LDAP, group, or database role, use task EDIS.usp_config_svc_id_perm.

Note: You can assign multiple ID’s, Groups, or database roles to the same service ID. Just run EDIS.usp_config_svc_id_perm for each group you want to assign to the role.

Stored Procedure: SSISDB.EDIS.usp_config_svc_id_perm

Parameters

Name Description Default Value
@svc_id Service ID to lock None; Required
@usr_id The domain login, domain group, or database role to assign/lock the service ID to. None; Required
@action Action to perform. To add a lock, set @action = ‘INSERT’. To delete a lock, set @action = ‘DELETE’ None; Required

Examples

Example 1: Assigning a domain login to service ID “SVC_ORA_P1”.

EXEC SSISDB.EDIS.usp_config_svc_id_perm

 @svc_id= 'SVC_ORA_P1'

,@usr_id = 'CON_PROD\DEV_USERS'

,@action = 'INSERT'

 
Example 2: Removing a domain login to service ID “SVC_ORA_P1”.

EXEC SSISDB.EDIS.usp_config_svc_id_perm

 @svc_id= 'SVC_ORA_P1'

,@usr_id = 'CON_PROD\DEV_USERS'

,@action = 'DELETE'