I imagine there's a few people that can, but you got me at a good
time.
The authority required to create a view is simply Select on the
objects
the view is on. If that Select privilege is revoked, so are
your rights
to have created that view, so it gets implicitly dropped. Can
make for
exciting times...

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG under
the Listserv tab. While at the site, you can also access the
IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at
no cost, click on Member Services

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG under
the Listserv tab. While at the site, you can also access the
IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at
no cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Raymond Bell

I knew my Pitmans Elementary Typing Certificate would come in handy
one day. For ridicule, mostly, but that's another story. Still, at
the time there were 40 students and one bloke (yours truly) so, as
a colleague of mine would say, do the math!

I imagine there's a few people that can, but you got me at a good
time. The authority required to create a view is simply Select on
the objects the view is on. If that Select privilege is revoked, so
are your rights to have created that view, so it gets implicitly
dropped. Can make for exciting times...

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at
IDUG.ORG <http://www.idug.org/lsidug>
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest IDUG conference information <http://www.idug.org/lsconf>
, and much more. If you have not yet signed up for Basic Membership
in IDUG, available at no cost, click on Member Services <
http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at
IDUG.ORG <http://www.idug.org/lsidug>
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest IDUG conference information <http://www.idug.org/lsconf>
, and much more. If you have not yet signed up for Basic Membership
in IDUG, available at no cost, click on Member Services <
http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at
IDUG.ORG <http://www.idug.org/lsidug>
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest IDUG conference information <http://www.idug.org/lsconf>
, and much more. If you have not yet signed up for Basic Membership
in IDUG, available at no cost, click on Member Services <
http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

IDUG.org was recently updated requiring members to use a new
password. You should have gotten an e-mail with the temporary
password assigned to your account. Please log in and update your
member profile. If you are not already an IDUG.org member, please
register at http://www.idug.org/component/juser/register.html