rob2xx2 wrote:

> In an application that has been running smoothly for around five
> years, I created a VIEW to make some data from two tables available to
> a third party application. I created a new user and granted them
> SELECT privileges on the VIEW. The other party at first said the link
> and VIEW worked fine but twice they have (correctly) reported that the
> VIEW disappeared. On the face of it there's no way a DROP VIEW command
> could have been executed.
>
> On reflection the SQL syntax I used was not the best - I used an
> implicit JOIN on the two tables, and I will replace that with better
> syntax.
>
> Are there any ways that a VIEW can be removed from a database other
> than by a DROP VIEW command? Is it possible that an implicit JOIN
> could cause a VIEW to be dropped after it has apparently been created
> and has delivered records to SELECT queries?
>
> I'm using Firebird version 1.5.
>
> Thanks for any comments and advice.
>
>

No way that I am aware of.

I don't know how would be the impact of a delete on rdb$relations table
on the views row, don't know if it will magically disappear (how would
be treated the dependencies and so on)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br