Print Page | Close Window

can we create a synonym of view which does not exi

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16421
Printed Date: 05 May 2024 at 12:09am


Topic: can we create a synonym of view which does not exi
Posted By: aarti
Subject: can we create a synonym of view which does not exi
Date Posted: 14 May 2012 at 12:15am
Hi,

I have created view in user TP2 and also grant that view to Saba_report user,
after that i deleted view form tp2 user, so the synonym should get invalid... Right?

But when i am using the same synonym in crystal report design, my report is working fine.. but the same synonym is available as invalid in database..

Please suggest...

Thanks in advance.


Replies:
Posted By: lockwelle
Date Posted: 14 May 2012 at 3:16am
my guess is that CR somehow stored the view internally.
 
Try a verify database and see if that doesn't invalidate your synonym.


Print Page | Close Window