Skip to Content
author's profile photo Former Member
Former Member

How do I append the owner to my queries?

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???

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2007 at 09:36 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2007 at 09:32 PM

    Post Author: dqrgk0

    CA Forum: Data Connectivity and SQL

    Thank you for the input Yangster.

    I'm sorry I forgot to mention that I have double-checked that my Set Datasource Location has been updated to reflect the correct database/table.

    Here is more info on the situation: 1) Connecting to database using the OBDC driver supplied by the system we are using, AR System (Remedy).2) Created the reports using our Remedy admin user name & password.3) The Report Server admin is using a user name & password of an account that was created for the sole purpose of scheduling the reports. ** When he tries to run the reports using that new account, the reports fail. If he uses our Remedy admin account, the reports run successfully.

    I still am not sure how or where I can append our db schema name to each query that is being issed to our database so that new account can run it without requiring a public synonym. I've been looking at the SQL Expressions but I still can't figure out how to make the application accept the schema owner identification: schemaowner.table.column .

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.