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

Thread: revoke drop table privs

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    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
    Location
    Dallas:TX:USA
    Posts
    407
    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
    Location
    New York,U.S.A.
    Posts
    245
    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.

    Dragon

  4. #4
    Join Date
    Jul 2000
    Posts
    296
    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