 |
Stefan Knecht |
at May 7, 2009 at 11:08 am
|
⇧ | 
| |
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.ch2009/5/7 Nagaraj S
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
