User ID impersonation to Data source

Summary:

User ID impersonation to Data source

Content (required):

When we are creating NR reports, we are giving Datasource connection hardcoded with Administrator Credentials.

So when a restricted user is accessing the report, the data which is restricted to Chandler to not see North and South data, will be available, as the data is pulled by service admin credentials.

Instead of Hardcoding this credentials, is there a way to pass the security from NR login to the datasource and thereby Source application security takes care to display the data that is allowed.?

Version (include the version you are using, if applicable):