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

Document ID : KB000126741
Last Modified Date : 12/02/2019
Show Technical Document Details
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.


 
Question:
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
Answer:
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