Re: Disable drop table privilege from the owner

In article <sll64crujev39_at_corp.supernews.com>,   Paul <paulhjli_at_hotmail.com> wrote:
> Hi,
> DBA user SYSTEM can disable the drop table privilege from the table
 owner,
> such as SCOTT/TIGER's emp?
>
> Thanks,
>
> Paul
>
> --
> Posted via CNET Help.com
> http://www.help.com/
>

In oracle8i release 8.1 using DDL triggers -- yes. Before that you can audit the fact they are dropped but not revoke the ability to drop them.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.