Skip to Content
avatar image
Former Member

How to disable modifications to Oracle Service in Crystal Reports 2016

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 :14.2.2.1975, Product Type:Full

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.