No Oracle/PLSQL, a sintaxe correta para a revogação de privilégios em tabelas é:
apply no privileges on object from user.
delete privileges on object from user.
revoke privileges on object from user.
revoke on object from user privileges.
on object from user delete privileges.
{TITLE}
{CONTENT}
{TITLE}
Aguarde, enviando solicitação...