Skip to Content
0
Former Member
Jul 19, 2008 at 09:40 AM

disable single sign on - oracle - Crystal XI

52 Views

Hi all !

We want to use Crystal Reports XI for our power users to generate their own reports.

Therefore i created some Reporting - db-users and the power users can logon on the oracle database like "reporting_XYZ" (=NO single sign on - fix password).

This reporting User owns some Synonyms to read only views to all "important" tables (=semantic layer).

But: Every power user is allready applied as a real Database-User (with oracle single sign on) for the production Database.

So i want them to use the "reporting"-Database-Schema to prevent they from logging in als their "real" database user (oracle single sign on) and updating/deleting any rows in the Production - Database.

I want to prevent the power users from "single sign on" with Crystal Reports.

If they would use single sign on, they had access to all tables in the Production Database.

And i dont want that (because you could use DML from Crystal to manipulate data in the database).

Therefore i created the "report" database users - these users just own a hand full of synonyms to read only view and nothing more.

Anyone got an idea, please ?

e.g. a registry key, telling CR XI to disable the single sign on checkbox ?

Edited by: Albert Benkert on Jul 19, 2008 11:43 AM