DROP ANY TABLE DBA System Privilege - Operations authorized to drop a table in any schema - Oracle Schema

Q.  Which DBA System Privilege used for the operations authorized for drops a table in any schema?
- Published on 19 Oct 15

a. CREATE USER
b. DROP USER
c. BACKUP ANY TABLE
d. DROP ANY TABLE

ANSWER: DROP ANY TABLE

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    - System privileges - Allow the grantee to perform standard administrator tasks in the database.

    - Restrict them only to trusted users.

    - Some of the privileges are:

    - BACKUP ANY TABLE - Use the Export utility to incrementally export objects from the schema of other users.

    - DROP ANY TABLE - Drop or truncate tables or table partitions in any schema

    - CREATE USER - Create users.
    - This privilege also allows the creator to:
    - Assign quotas on any tablespace.
    - Set default and temporary tablespaces.
    - Assign a profile as part of a CREATE USER statement.

    - DROP USER - Drop users

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲