Steve,

> Is there any prospect of being able to alter views? We use views and
> database access rights to enforce security but to change a view now
> involves dropping a large number of dependent views and SPs then
> granting privileges. This is prone to introducing error.

Firebird v1.5 introduces a new statement "RECREATE VIEW"

--
Sean Leyne

- FirebirdSQL Foundation, Sponsor - Silver Level
- FirebirdSQL Foundation, Member
- FirebirdSQL Project Admin (one of many)
http://www.FirebirdSQL.org