Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Crystal reports, synonyms, views and Security
"DA Morgan" <damorgan_at_exesolutions.com> wrote in message
news:3E4C700B.F04F573B_at_exesolutions.com...
> 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
>
I agree with Daniel. But this thread is off at a tangent, I think.
Synonyms are just shortcuts; they are *entirely* irrelevant to security.
You either do or do not have permissions on a given owner.dot.table; synonyms have *no* bearing on this whatsoever.
Regards,
Paul
Received on Fri Feb 14 2003 - 15:40:31 CST