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.
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;
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.
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.