Skip to Content
0
Former Member
Jan 06, 2012 at 11:23 AM

Single query which revoke all privilages assing in a user on oralce 10g

581 Views

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