Re: Crystal reports, synonyms, views and Security

Simon Dobner wrote:

> On Thu, 13 Feb 2003 05:59:39 +0000, Andrew Allen wrote:
>
> > The problem is the synonyms. Get rid of the synonyms.
> I can't do that ( or add new grants) without screwing up the application
> security. The grants, roles and synoyms are managed and controlled within
> the application, and it's really sensitive - I've killed my test database
> more than once trying various things and working out how it hangs
> together.
>
> > It seems that the
> > designer of your database went overboard in the number of layers of
> > 'insulation' he placed between the users and the data.
>
> Yeah, I don't think this one would pass Tom Kytes 'there is always a
> simple solution' test.
>
> Fortunately I discovered how to make Crystal reports behave the way I want
> it to, so for future reference, here it is
>
> You can remove the reference to the owner, leaving only the table name in
> the report.
>
> This is done by opening the report in the Crystal Report Designer.
>
> 1. From the menu bar select Database | Set Location. 2. In the text box
> which contains the "owner.table", remove the owner prefix and leave only
> the table name.
> 3. Do this for all tables in the main report and any subreports.
> 4. Save the report.
>
> Now when you connect to the report the database name used with the
> connection parameter is used.
>
> SD

Then don't connect to the synonyms ... connect to the tables by identifying them as schema_name dot table_name.

Synonyms can always be ignored.

Daniel Morgan Received on Thu Feb 13 2003 - 22:26:52 CST