Attachments uploaded to our internal repository should not be visible to external customers.

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

We have configured 2 repositories for attachments uploaded to tickets.
One of them is an internal repository and the attachments in this internal repository should not be visible to external customers.


 

We have configured 2 repositories for attachments uploaded to tickets.
One of them is an internal repository and the attachments in this internal repository should not be visible to external customers.
How to achieve this ?

Environment

CA Service Desk Manager - ANY version

Resolution

1. Let say that the repository for the customer attachments is called 
"Customer Attachments" and has id : 400003 

2. Create a data partition constraint of type 'View' on 'Attachments' table with the following  constraint: 
Type : View 
Table: Attachments 
Constraint: repository.id= 400003

3. Assign this data partition constraint to a user with 'Customer' access type. 

 Users with this access type can not see anymore the attachments in the internal repository, they can only see attachments in the repository with repository id : 400003

Note: you can set the data partition at user level, at access type level or at role level