Skip to Content
avatar image
Former Member

How to disable modifications to Oracle Service in Crystal Reports 2016

Nov 19, 2017 at 03:12 PM | 31 Views

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

SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 24, 2017 at 08:27 AM

      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.