Re: Drop Table Privilege

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Thu, 7 May 2009 13:08:57 +0200
Message-ID: <486b2b610905070408g17335102hf425d60341542ad0_at_mail.gmail.com>

If you own the table, you automatically have the right to drop it. If you want to drop someone else's table, you need to have DROP ANY TABLE.

Stefan

---

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

2009/5/7 Nagaraj S <nagaraj.chk_at_gmail.com>

> Hi Gurus,
>
>
>
> I have one basic clarification. I could not see “DROP TABLE” system
> privilege as separate privilege listed. which privilege gain a user to
> obtain “DROP TABLE” privilege.
>
>
>
> UPDATE ANY TABLE
>
> CREATE ANY TABLE
>
> UNDER ANY TABLE
>
> SELECT ANY TABLE
>
> INSERT ANY TABLE
>
> COMMENT ANY TABLE
>
> LOCK ANY TABLE
>
> CREATE TABLE
>
> ALTER ANY TABLE
>
> DELETE ANY TABLE
>
> DROP ANY TABLE
>
> BACKUP ANY TABLE
>
> FLASHBACK ANY TABLE
>
>
> -Naga
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 07 2009 - 06:08:57 CDT