Re: Oracle privileges and Crystal Reports

> The tables used are set when the report is designed..If the user running the report does
> not have select ( at a minimum)
> rights to the table the report will fail.
> Usually, Crystal will use the fully-qualified table name i.e. schema.table_name, so it
> should never try to access any other
> table.
>
> Use the Show Sql ( under the database manu option ) to see exactly what table(s) are being referenced..
> Use the 'Verify Database' command ( same menu) to be sure it is correct..

Thanks for your reply!

I made the report on a database with all roles and privileges granted, would that be a problem?

The report worked for a couple of days and started to intermittently fail, it doesn't work at all anymore and the database hasn't changed. The schema qualifications have been removed from the table names in CR so that they can be added dynamically by an application modifying the SQL and then exporting the report, the final SQL looks fine. The server contains other databases of the same structure and at first I thought that maybe CR was referring to the wrong table but the table name is correctly qualified, I'm at a loss as to what's wrong.

Also, there a couple of tables in the database that when I add them to the report in CR I get an ODBC 'Driver not capable' error and CR won't link to them. It's always the same tables and it happens when I re-import the database as well, any idea what that could mean?

kristoff plasun Received on Tue Feb 03 2004 - 19:52:59 CST