Skip to Content

How to disable modifications to Oracle Service in Crystal Reports 2016

Nov 19, 2017 at 03:12 PM


avatar image

Currently users who design the reports using the CR Developer are not allowed to test against the Live/Production Oracle database using native Oracle Connection(Data Explorer -> Oracle Server). The issue is some of the designers are from the production support team and are aware of the credentials of the Oracle Live Server. They always tend to test the reports against Live Oracle Database, which is not permitted despite repeated reminders.

Is there anyway to restrict the designers who launch CR developer (other production users launch only Crystal Reports Viewer) :

  1. are defaulted to test environment of Oracle Server only ( Oracle Service should be defaulted to Test Server when they launch CR Developer)
  2. Disallow the operation of modifying the Oracle Service

.Additional Details:

Product : SAP Crystal Reports 2016 SP2, Version :, Product Type:Full

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Nov 20, 2017 at 10:22 AM

Hi Donna,

You cannot enforce such restrictions from the CR Designer, unfortunately.

You could perhaps disable modifications to the TNSNames.ora for such users and enter connection details for the Test Server in this file.


Show 1 Share
10 |10000 characters needed characters left characters exceeded

We have entered the connection details of Test Server in TNSNames.ora but they key-in the complete TNS Live Oracle Service by replacing the Test Oracle Service after launching the CR Designer.