Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop any table vs. delete any table
Why can't they have just truncate table privilege that would include only
authorizations needed for truncation?
(I don't really want to allow dropping single or multiple tables).
Yuri
David wrote:
> Drop any table is the correct privilege, it is required to move extents from
> uet$ to fet$, I would agree that we should have a more granular privilege
> (e.g. drop table would be nice).
>
> regards
> David
>
> Gregg Sporar wrote in message <34F4937D.AC216599_at_i2.com>...
> >In several places in the documentation it states that to do a TRUNCATE
> >on a table that is not in your own schema you have to have the DELETE
> >ANY TABLE system privilege. In testing under v7.2.3 on HP-UX and v7.3.3
> >under NT, however, I get an "insufficient privilege" error when
> >attempting a TRUNCATE of a table that is not in my schema. The only way
> >I have found to fix this is to be granted the DROP ANY TABLE system
> >privilege. My question is: Does anyone know if this is a bug in the
> >code that might someday get fixed, or is the documentation wrong?
> >
> >Please respond to my email address (gregg_sporar_at_i2.com) as our news
> >server seems to be having some problems....
> >
> >Thanks,
> >Gregg
> >
Received on Fri Mar 06 1998 - 00:00:00 CST