Declined
Last Updated: 01 Dec 2017 14:56 by ADMIN
Jerel
Created on: 31 Mar 2016 16:27
Type: Feature Request
2
Connection String Security
A great feature would be to add security over the connection strings that a user can choose from in the server. We have a development and production environment and we want to allow people to write reports but we don't want them hitting production data because they don't always build efficient queries which can take the production database down.

This would help allow access to development and production separately and help keep the DBA from yelling at me :)
1 comment
ADMIN
Milen
Posted on: 01 Dec 2017 14:56
Explained that way, it seems that the users creating the reports should only have access to the development database instance. User permissions support that. Assign the users that design reports to the Report Creators role only and modify this role to have access to the development data connection only instead of all data connections. When a report is ready for production usage, you can open it for edit and change the target connection string for its data source to the production one.