i have ecc 6.0 and oracle 10g database.
and 1 user "test" which contains the lots of privileges.
i see on dba_sys_privs and dba_role_privs.
Now my question is that i want to revoke all the privileges which is assign to test user;
in dba_sys_privs contains 158 roles.
please give me the single revoke query which revoke all sys privileges.
Regards,
Vivek