Came across this useful stuff……
Oracle allows any user to perform exp and imp into his/her schema.
Being an Admin, if you do not want all users to exp/imp their data
Revoke SELECT privilege on sys.EXU8FUL from public.
sql>revoke select on EXU8FUL from public;
Reference: http://forums.oracle.com/forums/thread.jspa?threadID=610755&start=0&tstart=0
[...] Prevent the use of EXP and IMP for specified Oracle Users Filed under: Oracle Utilities — jennyca @ 1:26 pm SQL> revoke select on EXU8FUL from public; An useful trick from boomslaang [...]
Pingback by Prevent the use of EXP and IMP for specified Oracle Users « Jennifer Lin’s Weblog — June 10, 2008 @ 10:26 pm |
[...] Revoke exp/imp from non privileged oracle users [...]
Pingback by Index « My confrontations with oracle — April 6, 2009 @ 2:50 pm |