Comment
Above in this comment thread:
More Random Thoughts » Possibilities in DB2
Probably not a "dirty trick"
Posted by
cmullins
at
2005-08-16 03:49 PM
A view or a materialized query table is dropped when the SELECT privilege that was used to create it is revoked, unless the owner of the view or materialized query table was directly granted the SELECT privilege from another source before the view or materialized query table was created.
