DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Feb 2000
    New York,U.S.A.
    Hi, all
    I have a user with connect,resource roles, but I'd like to revoke drop table privs from that user, when I do the command it gives me:
    SQL> revoke drop table from ukhub2;
    revoke drop table from ukhub2
    ERROR at line 1:
    ORA-00990: missing or invalid privilege

    What is wrong with my syntax?
    Thanks for help.

  2. #2
    Join Date
    Oct 2000
    The privilege name is "DROP ANY TABLE"
    This is a SYSTEM privilege; You cannot grant or revoke DROP on selective tables.
    So it should be --

    revoke drop ANY table from ukhub2;

    - Rajeev

    Rajeev Suri

  3. #3
    Join Date
    Feb 2000
    New York,U.S.A.
    Thanks, the user does not have DROP ANY TABLE privs. I'd like to know is there any way we can grant a user any privs but not drop table. Because I do not want that user to drop tables, he can do whatever he want but not dropping tables.
    Any help to accomplish this is appreciated.


  4. #4
    Join Date
    Jul 2000
    If the table is in the users schema (s)he can drop the table. You can drop everything in your own schema. To prevent the user from dropping tables, create the tables in another schema.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.