Skip to Content
0
Former Member
Jun 11, 2007 at 09:09 PM

How do I append the owner to my queries?

23 Views

Post Author: dqrgk0

CA Forum: Data Connectivity and SQL

We are using Crystal 10, Crystal Enterprise 10, Oracle 9i.

The reports created are scheduled to be run by an account created with read-only 'select' grants to the tables/views. When this account is used to run the reports, it is receiving error messages:

Report 1 (a 3-table join) : "table not found"Report 2 (a view created on the DB) : "VIEW_NAME.FIELD1 = "Field_Value" name is not known."

Our DBA states that without the use of synonyms (which she states would be the last resort due to security & other things) all of the Crystal queries in my report will need to be appended with the schema owner name like:

SELECT * from SchemaName.VIEW_NAME

I have already provided the DBA all the underlying table names, views, etc.

Crystal has it's own SQL syntax it uses...How can I modify my Crystal queries to achieve the aforementioned SELECT example? Is there a place where I can set the schema name???