Re: grant drop table?

From: Maurice E. Jarrell <mejarrell_at_worldnet.att.net>
Date: Sat, 04 Nov 2000 23:06:42 GMT
Message-ID: <m3y9yzejtj.fsf@localhost.localdomain>

"Howard J. Rogers" <howardjr_at_www.com> writes:

> Short answer: no, not in the literal way you've described it here.
>

Agreed. But, there may be some rather kludgey work-arounds, to whit:

Run a job each night which identified all the tables owned by users with that role and grant "all" on those tables to the other users with that role?
Train said users to grant "all" on the tables they create to the role?

I know, I know. What was I thinking?

Mo. Received on Sat Nov 04 2000 - 17:06:42 CST