Hi Sean,

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

And how exactly is this going to help him? Isn't this a shorthand for
DROP, CREATE? And don't throw errors if it doesn't exist?


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> --
> Sean Leyne
>
> - FirebirdSQL Foundation, Sponsor - Silver Level
> - FirebirdSQL Foundation, Member
> - FirebirdSQL Project Admin (one of many)
> http://www.FirebirdSQL.org
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>