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.