FAQ
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

Search Discussions

  • 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.ch

    2009/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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 7, '09 at 11:03a
activeMay 7, '09 at 11:08a
posts2
users2
websiteoracle.com

2 users in discussion

Nagaraj S: 1 post Stefan Knecht: 1 post

People

Translate

site design / logo © 2022 Grokbase